| From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | dump/restore failing in 7.1.2 |
| Date: | 2001-08-14 23:53:23 |
| Message-ID: | 3B79B9F3.4070202@selectacast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dwayne Miller | 2001-08-15 00:22:31 | Re: PostgresQL equivalent of NOCOUNT |
| Previous Message | Joseph Shraibman | 2001-08-14 23:12:49 | Re: LARGE db dump/restore for upgrade question |