Re: [ADMIN] relation tmp_pg_shadow already exists

2005-01-31 Thread Ben Kim
Thanks for the prompt help. The problem seems to be missing users. Removing -C revealed the problem. > Other than that, though, the only thought that comes to mind is that you > may be confused about the use of -C. IIRC, specifying it at dump time > is useless --- it needs to be given to pg_rest

Re: [ADMIN] relation tmp_pg_shadow already exists

2005-01-31 Thread Tom Lane
Ben Kim <[EMAIL PROTECTED]> writes: > I'm trying to restore a tar dump of postgresql 7.2 databases into a 7.3 > server. I have two databases (db1,db2) both containing binary data. The > tar was dumped with the following command: > pg_dump -C -b -F t -i db1.tar db1 > The first one was restor

[ADMIN] relation tmp_pg_shadow already exists

2005-01-31 Thread Ben Kim
Operating System: Fedora core 1 From: postgresql 7.2 database To: postgresql 7.3 database I'm trying to restore a tar dump of postgresql 7.2 databases into a 7.3 server. I have two databases (db1,db2) both containing binary data. The tar was dumped with the following command: pg_dump -C