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=3D#
musket=3D# \dt public.*
No matching relations found.
musket=3D#
musket=3D# \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.ucsf.edu
--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
