Re: search_path when restoring to new db - Mailing list pgsql-general

From SunWuKung
Subject Re: search_path when restoring to new db
Date
Msg-id 1165911536.223599.11510@80g2000cwy.googlegroups.com
Whole thread Raw
In response to Re: search_path when restoring to new db  ("Brandon Aiken" <BAiken@winemantech.com>)
Responses Re: search_path when restoring to new db  ("Brandon Aiken" <BAiken@winemantech.com>)
List pgsql-general
Ok, I understand this difference now.
Knowing that, what is the standard way to copy a single database to
another server?

- can I use pg_dumpall to dump a single db? - or
- I have to use pg_dump and there is a procedure to ensure that old and
new dbs are the same, like

1. create new db
2. check or create user
3. run pg_restore
4. do alter db

and is there a way to automate this? If there is could you point me
there?

If there isn't:
Do you think that automating the complete backup and restore of a
single database would be database specific or it could work with
different databases? Don't you think that this is something that would
be generally useful?

Thank you for the help.
Balázs


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Why DISTINCT ... DESC is slow?
Next
From: Anton
Date:
Subject: Re: Why DISTINCT ... DESC is slow?