Re: Upgrading on RH72 - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Upgrading on RH72
Date
Msg-id Pine.LNX.4.44.0208101843550.14354-100000@cm-lcon1-46-187.cm.vtr.net
Whole thread Raw
In response to Re: Upgrading on RH72  (Patrick Nelson <pnelson@neatech.com>)
List pgsql-general
Patrick Nelson dijo:

> I have simply host based access like:
>
>  local        all                                            trust
>  host         all         127.0.0.1      255.255.255.255     trust
>  host         all         xxx.xxx.xxx.0  255.255.0.0         trust
>
> A "service postgresql restart" and "psql -e template1 < pg-upg-dump.sql"
> errors a bit differently:
>
>   psql: FATAL 1: user "root" does not exist

I guess you should start reading the manuals for things.  Try to connect
using the username that your application uses.

But you'll have to createuser that user first, probably.

If then it complains that it cannot connect to the database
such-and-such, create it using createdb.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Entristecido, Wutra
echa a Freyr a rodar
y a nosotros al mar" (cancion de Las Barreras)


pgsql-general by date:

Previous
From: Patrick Nelson
Date:
Subject: Re: Upgrading on RH72
Next
From: Patrick Nelson
Date:
Subject: Re: Upgrading on RH72