Re: restore a dump db from tar file
| От | Alain Roger |
|---|---|
| Тема | Re: restore a dump db from tar file |
| Дата | |
| Msg-id | 75645bbb0810060812x5c956781o47def77bb89111ea@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: restore a dump db from tar file (Raymond O'Donnell <rod@iol.ie>) |
| Ответы |
Re: restore a dump db from tar file
Re: restore a dump db from tar file |
| Список | pgsql-general |
On Mon, Oct 6, 2008 at 3:12 PM, Raymond O'Donnell <rod@iol.ie> wrote:
On 06/10/2008 14:03, Alain Roger wrote:Just a guess, since I haven't used pg_restore - a quick look at the docs
> this is basically what i use but it does not work.
>
> pg_restore -C -d sewe survey.tar -U postgres
suggests that the filename should come *last* on the command line, so
try that.
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
AFAIK, pg_dump -v -o -U username -ci -Ft -f tarname.tar dbname
backup the DB but without inserting code to create the BD itself... just to create its structure and populate it.
noting about create database dbname
grant. ...
how can i do that automatically ?
i mean when i dump my db, how can i dump ALSO the script to create the BD and its property ?
thx.
В списке pgsql-general по дате отправления: