| From: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
|---|---|
| To: | Patrick Nelson <pnelson(at)neatech(dot)com> |
| Cc: | "PostgreSQL List (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Upgrading on RH72 |
| Date: | 2002-08-10 22:49:39 |
| Message-ID: | Pine.LNX.4.44.0208101843550.14354-100000@cm-lcon1-46-187.cm.vtr.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Nelson | 2002-08-10 22:58:54 | Re: Upgrading on RH72 |
| Previous Message | Lamar Owen | 2002-08-10 22:47:18 | Re: Upgrading on RH72 |