Thread

1. Reloading a 6.3db into 6.4.1

   Stan Brown <stanb@awod.com> — 1999-01-04T03:49:11Z

   	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?
   
   -- 
   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 and
   	a graphical shell for a 16-bit patch to an 8-bit operating system
   	originally coded for a 4-bit microprocessor, written by a 2-bit 
   	company that can't stand for 1 bit of competition.
   -
   (c) 1999 Stan Brown.  Redistribution via the Microsoft Network is prohibited.
   
   

2. Re: [HACKERS] Reloading a 6.3db into 6.4.1t

   Bruce Momjian <maillist@candle.pha.pa.us> — 1999-01-04T04:44:13Z

   > 	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, Pennsylvania 19026