Postgres Pro
Downloads
Home   >   mailing lists

Migration of postgres 7.3 to postgres 7.4 from one server to another server - Mailing list pgsql-novice

From Leena JAIN
Subject Migration of postgres 7.3 to postgres 7.4 from one server to another server
Date
Msg-id 007901c53e8c$9112d040$139601ca@dlh.st.com
Whole thread Raw
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Simple function closes connection to server
Next
From: Andy Dunlop
Date:
Subject: Postgres startup