Thread: Reloading a 6.3db into 6.4.1
I am having problems reloading my 6.3 dump inot 6.4.1 Heres what I amseeing: \connect template1 postgres connecting to new database: template1 as user: postgres create database stan; QUERY: create database stan; CREATEDB \connect stan postgres connecting to new database: stan as user: postgres \connect - stan connecting as new user: stan FATAL 1: SetUserId: user 'stan' is not in 'pg_shadow' Could not connect to new database. exiting What am I doing wrong here? -- Stan Brown stanb@netcom.com 843-745-3154 Westvaco Charleston SC. -- Windows 98: n.useless extension to a minor patch release for 32-bit extensions anda graphical shell for a 16-bit patch toan 8-bit operating systemoriginally coded for a 4-bit microprocessor, written by a 2-bit company that can't stand for 1bit of competition. - (c) 1999 Stan Brown. Redistribution via the Microsoft Network is prohibited.
> I am having problems reloading my 6.3 dump inot 6.4.1 Heres what I am > seeing: > > \connect template1 postgres > connecting to new database: template1 as user: postgres > create database stan; > QUERY: create database stan; > CREATEDB > \connect stan postgres > connecting to new database: stan as user: postgres > \connect - stan > connecting as new user: stan > FATAL 1: SetUserId: user 'stan' is not in 'pg_shadow' > > Could not connect to new database. exiting > > What am I doing wrong here? Did you use pg_dump preseving the users, but did not user pg_dumpall, which creates the users. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026