Failed to restore/recreate database

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

Browse pgsql-admin by date

  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?