Postgres Pro
Downloads
Home   >   mailing lists

dump/restore failing in 7.1.2 - Mailing list pgsql-general

From Joseph Shraibman
Subject dump/restore failing in 7.1.2
Date
Msg-id 3B79B9F3.4070202@selectacast.net
Whole thread Raw
List pgsql-general
Tree view 
In dumping from one 7.1.2 install and trying to restore in another fresh
install:


You are now connected to database template1.
DELETE 0
psql:/local/dumpall-8-14:7: ERROR:  CREATE USER: sysid 101 is already
assigned
CREATE USER
DELETE 0
You are now connected to database template1 as user postgres.
CREATE DATABASE
You are now connected to database <mydb> as user postgres.
psql:/local/dumpall-8-14:22: \connect: FATAL 1:  user
"<username-goes-here>" does not exist

--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: LARGE db dump/restore for upgrade question
Next
From: "Dwayne Miller"
Date:
Subject: Re: PostgresQL equivalent of NOCOUNT