Migration of postgres 7.3 to postgres 7.4 from one server to another server

From: Leena JAIN <leena(dot)jain(at)st(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Migration of postgres 7.3 to postgres 7.4 from one server to another server
Date: 2005-04-11 11:49:49
Message-ID: 007901c53e8c$9112d040$139601ca@dlh.st.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I am trying to migrate postgres 7.3 to postgres 7.4 from one server to another server. I am doing this with following command.

pg_dumpall –h 123.345.567.xxx | tee dump | psql –v ON_ERROR_STOP= –a template1 2>&1 | tee log

It is giving me following error

pg_dumpall: could not connect to database "template1": FATAL: No pg_hba.conf entry for host 111.111.222.222, user postgres, database template1

Thanks a lot for your help

BR
Leena

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ennio-Sr 2005-04-11 12:57:13 Re: how to ignore accents?
Previous Message Kaloyan Iliev Iliev 2005-04-11 10:42:00 Re: Postgres Out of Memory