2) drop database and create it from the scratch.
fastest way if you do
not want to save history.
is there an easy way to do this ? for dummies ? :)
________________________________________
Fra: fred-users-bounces(a)lists.nic.cz [fred-users-bounces(a)lists.nic.cz] På vegne
af Jaromír Talíř [jaromir.talir(a)nic.cz]
Sendt: 2. december 2008 15:31
Til: fred-users(a)lists.nic.cz
Emne: Re: delete test data from postgre sql
I see two ways:
1) write script that iterate over all objects and call delete command
using fred-client (this is if you want to save history of these
commands)
2) drop database and create it from the scratch. fastest way if you do
not want to save history.
Jaromir
Petur Kirke píše v Út 02. 12. 2008 v 15:01 +0000:
As i am programming and testing, i have filled up
the PostgreSQL database of FRED with testdata.
Now i would like the delete all the data, which means all domains, contacts, nssets etc.
Is there some fast way to do this ? or do i have to empty every table, one at a time ?
and would that solution be secure ?
regards
Petur
________________________________________
Fra: fred-users-bounces(a)lists.nic.cz [fred-users-bounces(a)lists.nic.cz] På vegne
af Jaromír Talíř [jaromir.talir(a)nic.cz]
Sendt: 28. november 2008 17:31
Til: fred-users(a)lists.nic.cz
Emne: Re: contact ID
This Fred feature is called "handle protection". We decided to prevent
handle from it's immediate registration to protect contacts. Imagine
situation when some domain is registered for contact C123 and this
person will switch to use different contact handle for it's domain and
delete old unused contact C123. Someone can register C123 and claim to
registrar that he is original owner of domain. We think registrar need
some time for example to do update of its own contact database. After
some time (2 month) this contact is not protected anymore and anybody
can register it.
Jaromir
Petur Kirke píše v Po 24. 11. 2008 v 15:57 +0000:
I was trying to create contacts programmatically,
something like this:
create_contact ID1 ...
and i get this response:
Return code: 2005
Reason: Parameter value syntax error
ERROR: Element that caused a server error condition: <contact:id
xmlns:contact='http://www.nic.cz/xml/epp/contact-1.4'>ID1</contact:id>
Reason: within protection peridod.
I think the reason is because ID1 is already in the database, right ?
and how long is this protection period ? when can i insert this ID again ?
This email and its attachments may be confidential and are intended solely for the use of
the individual to whom it is addressed.
If you are not the intended recipient or authorized to receive information for the
intended recipient you are notified that disclosing, copying, distributing or taking any
action in reliance on the contents of this information is strictly prohibited. If the
email contains proposals, they are valid for 30 days following the date of email
transmission. Finally, the recipient should check this email and any attachment for the
presence of viruses. The company accepts no liability for any damage caused by any virus
transmitted by email.
_______________________________________________
Fred-users mailing list
Fred-users(a)lists.nic.cz
https://lists.nic.cz/mailman/listinfo/fred-users
This email and its attachments may be confidential and are intended solely for the use of
the individual to whom it is addressed.
If you are not the intended recipient or authorized to receive information for the
intended recipient you are notified that disclosing, copying, distributing or taking any
action in reliance on the contents of this information is strictly prohibited. If the
email contains proposals, they are valid for 30 days following the date of email
transmission. Finally, the recipient should check this email and any attachment for the
presence of viruses. The company accepts no liability for any damage caused by any virus
transmitted by email.
_______________________________________________
Fred-users mailing list
Fred-users(a)lists.nic.cz
https://lists.nic.cz/mailman/listinfo/fred-users
This email and its attachments may be confidential and are intended solely for the use of
the individual to whom it is addressed.
If you are not the intended recipient or authorized to receive information for the
intended recipient you are notified that disclosing, copying, distributing or taking any
action in reliance on the contents of this information is strictly prohibited. If the
email contains proposals, they are valid for 30 days following the date of email
transmission. Finally, the recipient should check this email and any attachment for the
presence of viruses. The company accepts no liability for any damage caused by any virus
transmitted by email.
_______________________________________________
Fred-users mailing list
Fred-users(a)lists.nic.cz