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

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

> 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

It cannot authenticate (the server refuses to open connection). Look at
pg_hba.conf (authentication), you can set it to "trust" temporarily, if it
is not on the Internet...

Vlad