From: | Andreas Tille <tillea(at)rki(dot)de> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | pgdump |
Date: | 2000-09-19 07:15:32 |
Message-ID: | Pine.LNX.4.21.0009181630220.1778-100000@wr-linux02.rki.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
if I do a database dump via pg_dump also PostgreSQL internal tables
named pga_* are stored in the dump. However if I drop a database and
create it via "create database <name>" those tables are created
automatically. Restoring the old content of the database using
cat <name>.dump | psql <name>
leads to warning messages caused by the existence of the pga_*
tables. This is really annoing. I checked all pg_dump options
if this could be avoided, but didn't found any.
I wonder if I should write a little script to remove the pga_*
stuff from the dump to get a warning-free restore.
Is there any usual solution for this problem?
Kind regards
Andreas.
From | Date | Subject | |
---|---|---|---|
Next Message | Forest Wilkinson | 2000-09-19 07:28:08 | Re: Can't connect to 6.5.2 server with 7.0.2 client |
Previous Message | Charles Tassell | 2000-09-19 06:13:42 | Re[2]: WTF is going on with PG_VERSION? |