frequent refresh of database in postgresql

Asked by Lakhan Agarwal

Please tell me what is the best way to get refresh of production database on the test database.
 I have used two ways-
 1.importing dumpall and dropping the databases.

2.importing dumpall and dropping all the relations.

Thanks
 Lucky

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu postgresql-common Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Thomas Krüger (thkrueger) said :
#1

Depends on what fits best for your needs. You should read http://www.postgresql.org/docs/9.1/static/backup.html .

Can you help with this problem?

Provide an answer of your own, or ask Lakhan Agarwal for more information if necessary.

To post a message you must log in.