Re: Facing authentication error on postgres 9.2 -> dblink functions
| От | Dev Kumkar |
|---|---|
| Тема | Re: Facing authentication error on postgres 9.2 -> dblink functions |
| Дата | |
| Msg-id | CALSLE1OjXARwOsCTKBUZLTrr8Bk16DYk1RSmx9Oe_guLcrEm7A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Facing authentication error on postgres 9.2 -> dblink functions (Dev Kumkar <devdas.kumkar@gmail.com>) |
| Ответы |
Re: Facing authentication error on postgres 9.2 -> dblink functions
|
| Список | pgsql-admin |
Hey went ahead and tried to query across machines and facing following error:
SELECT * FROM dblink_connect('host=x.x.x.x port=5432 dbname=postgres user=postgres password=test')
could not connect to server: Connection timed out (0x0000274C/10060)
Is the server running on host "x.y.z.com" (x.x.x.x) and accepting
TCP/IP connections on port 5432?
Tried modifying pg_hba as follows:
1st try
host all all 0.0.0.0/0 md5
2nd try
host all all .z.com md5
postgresql.conf looks good for connections and authentication:
listen_addresses = '*'
Please suggest?
Thanks...
SELECT * FROM dblink_connect('host=x.x.x.x port=5432 dbname=postgres user=postgres password=test')
could not connect to server: Connection timed out (0x0000274C/10060)
Is the server running on host "x.y.z.com" (x.x.x.x) and accepting
TCP/IP connections on port 5432?
Tried modifying pg_hba as follows:
1st try
host all all 0.0.0.0/0 md5
2nd try
host all all .z.com md5
postgresql.conf looks good for connections and authentication:
listen_addresses = '*'
Please suggest?
Thanks...
On Wed, Feb 6, 2013 at 11:25 PM, Dev Kumkar <devdas.kumkar@gmail.com> wrote:
Great.. thanks a lot Laurenz Albe!
Works perfect !!
Regards - DevOn Wed, Feb 6, 2013 at 7:00 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:You should specify a user=username option in the connection string,Dev Kumkar wrote:
> I am using postgres 9.2 and when executing function dblink facing a fatal error while trying to
> execute dblink_connect as follows:
>
> SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres password=test')
>
> ERROR: could not establish connection DETAIL: FATAL: password authentication failed for user
> "NETWORK SERVICE"
>
> What this error is related to? Do I need to modify pg_hba.conf file by any chance?
otherwise that defaults to your operating system user name.
Yours,
Laurenz Albe
В списке pgsql-admin по дате отправления: