On Sun, Mar 03, 2002 at 10:58:37PM +0100, Keld J�rn Simonsen wrote: > On Sun, Mar 03, 2002 at 10:12:12PM +0100, Keld J�rn Simonsen wrote: > > When trying to move my databases I had problems with > > postgres, psql says that > > psql: FATAL 1: Database "postgres" does not exist in the system > > catalog. > > It probably should be defined as a default database. > > I got to get further by doing > > psql template1 < database-dump > > but there were a number of problems upgrading my databases like: > \connect: FATAL 1: IDENT authentication failed for user "keld" > althogh this user was just created. > And a number of syntax errors. > > I am upgrading from postgres 7.1.3 (RH 7.2) (to 7.2) > I actually thought that my dbs did not need > to be upgraded, given that it was the same major version > number (7).
I got the problem solved in the first case, I had to s/'current_date'/CURRENT_DATE/ on the sql-ledger databases, in the saved database from psql 7.1.3. Keld
