From: | Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Failed to restore/recreate database |
Date: | 2009-11-16 17:10:40 |
Message-ID: | C726C790.8BA0%tsakai@gallo.ucsf.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi everybody,
I wanted to duplicate a database, but wound up with nothing,
It seems. I am using 8.3.7 on redhat linux. Here's what I
did (as user postgres):
bash-3.00$ createdb musket
bash-3.00$
bash-3.00$ df /pgsql
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup01-LogVol02
1548184780 358554536 1110987044 25% /pgsql
bash-3.00$
bash-3.00$ createdb musket
bash-3.00$
bash-3.00$ gunzip /home/postgres/backup/20091114.6.gz | psql -d musket -f -
bash-3.00$
bash-3.00$ echo $?
0
bash-3.00$
bash-3.00$ psql musket
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
musket=#
musket=# \dt public.*
No matching relations found.
musket=#
musket=# \q
bash-3.00$
bash-3.00$ df /pgsql
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup01-LogVol02
1548184780 358554564 1110987016 25% /pgsql
bash-3.00$
There must be something wrong with the way I used psql with the option
(-f -), although I can't see what that would be. The file 20091114.6.gz
was made by:
pg_dumpall | gzip > 20091114.6.gz
Would someone please clue me in?
Regards,
Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu
From | Date | Subject | |
---|---|---|---|
Next Message | Tena Sakai | 2009-11-16 17:26:32 | Failed to restore/recreate database (one more piece of info) |
Previous Message | Milen A. Radev | 2009-11-16 14:55:18 | Re: Can i write a time-trigger? |