pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedConnecting to a remote db server
12+ messages / 4 participants
[nested] [flat]
* Connecting to a remote db server
@ 2013-07-10 21:58 Struckhoff, Kevin <kstruckhoff@ebay.com>
0 siblings, 2 replies; 12+ messages in thread
From: Struckhoff, Kevin @ 2013-07-10 21:58 UTC (permalink / raw)
To: pgsql-admin
I've installed postgres 9.2 on a server, call it db01. I now want to access postgres from my app server, call it app01.
What do I install on the app01 server? I've installed postgres 9.2 on it and set the postgresesql.conf file's listen_address to a value of '*' on both machines. I've also modified the pg_hba.conf file to be wide open for now on both machines.
It seems that something else is missing or needs to be done. Googling wasn't much help, the results weren't current.
Any help would be appreciated. Thanks.
Kevin Struckhoff
kstruckhoff@ebay.com
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Connecting to a remote db server
@ 2013-07-10 22:22 Alvaro Herrera <alvherre@2ndquadrant.com>
parent: Struckhoff, Kevin <kstruckhoff@ebay.com>
1 sibling, 1 reply; 12+ messages in thread
From: Alvaro Herrera @ 2013-07-10 22:22 UTC (permalink / raw)
To: Struckhoff, Kevin <kstruckhoff@ebay.com>; +Cc: pgsql-admin
Struckhoff, Kevin wrote:
> I've installed postgres 9.2 on a server, call it db01. I now want to access postgres from my app server, call it app01.
>
> What do I install on the app01 server? I've installed postgres 9.2 on it and set the postgresesql.conf file's listen_address to a value of '*' on both machines. I've also modified the pg_hba.conf file to be wide open for now on both machines.
>
> It seems that something else is missing or needs to be done. Googling wasn't much help, the results weren't current.
What's your operating system? There are two separate pieces, client and
server. On the application side you don't need the server packages, so
normally there's no postgresql.conf file there at all, and no
pg_hba.conf either; both are server-side only configuration files. You
just need libpq, and whatever client libraries your apps use.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Connecting to a remote db server
@ 2013-07-10 22:24 Kevin Grittner <kgrittn@ymail.com>
parent: Struckhoff, Kevin <kstruckhoff@ebay.com>
1 sibling, 1 reply; 12+ messages in thread
From: Kevin Grittner @ 2013-07-10 22:24 UTC (permalink / raw)
To: Struckhoff, Kevin <kstruckhoff@ebay.com>; pgsql-admin
"Struckhoff, Kevin" <kstruckhoff@ebay.com> wrote:
> I've installed postgres 9.2 on a server, call it db01. I now want
> to access postgres from my app server, call it app01.
>
> What do I install on the app01 server? I've installed postgres
> 9.2 on it and set the postgresesql.conf file's listen_address to
> a value of '*' on both machines. I've also modified the
> pg_hba.conf file to be wide open for now on both machines.
The postgresesql.conf and pg_hba.conf files aren't used on the
client side -- those only matter on the server.
> It seems that something else is missing or needs to be done.
> Googling wasn't much help, the results weren't current.
How are you trying to connect, and what happens when you try?
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Connecting to a remote db server
@ 2013-07-10 22:27 Struckhoff, Kevin <kstruckhoff@ebay.com>
parent: Alvaro Herrera <alvherre@2ndquadrant.com>
0 siblings, 1 reply; 12+ messages in thread
From: Struckhoff, Kevin @ 2013-07-10 22:27 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@2ndquadrant.com>; +Cc: pgsql-admin
Sorry, rhel 5.8. so there is a separate client install package?
Kevin Struckhoff, TDWI
Sr. IT Mgr, LA DR Operations
kstruckhoff@ebay.com ebayenterprise.com
o: 818.686.4719 | c: 818.968.0634 |
The information contained in this electronic mail transmission is intended only for the use of the individual or entity named in this transmission. If you are not the intended recipient of this transmission, you are hereby notified that any disclosure, copying or distribution of the contents of this transmission is strictly prohibited and that you should delete the contents of this transmission from your system immediately. Any comments or statements contained in this transmission do not necessarily reflect the views or position of eBay Enterprise or its subsidiaries and/or affiliates.
-----Original Message-----
From: Alvaro Herrera [mailto:alvherre@2ndquadrant.com]
Sent: Wednesday, July 10, 2013 3:23 PM
To: Struckhoff, Kevin
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Connecting to a remote db server
Struckhoff, Kevin wrote:
> I've installed postgres 9.2 on a server, call it db01. I now want to access postgres from my app server, call it app01.
>
> What do I install on the app01 server? I've installed postgres 9.2 on it and set the postgresesql.conf file's listen_address to a value of '*' on both machines. I've also modified the pg_hba.conf file to be wide open for now on both machines.
>
> It seems that something else is missing or needs to be done. Googling wasn't much help, the results weren't current.
What's your operating system? There are two separate pieces, client and
server. On the application side you don't need the server packages, so
normally there's no postgresql.conf file there at all, and no
pg_hba.conf either; both are server-side only configuration files. You
just need libpq, and whatever client libraries your apps use.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Connecting to a remote db server
@ 2013-07-10 22:33 Struckhoff, Kevin <kstruckhoff@ebay.com>
parent: Kevin Grittner <kgrittn@ymail.com>
0 siblings, 2 replies; 12+ messages in thread
From: Struckhoff, Kevin @ 2013-07-10 22:33 UTC (permalink / raw)
To: Kevin Grittner <kgrittn@ymail.com>; pgsql-admin
I'm trying to use the psql tool:
/home/postgres->psql test
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
the answer of course is No..
Kevin Struckhoff, TDWI
Sr. IT Mgr, LA DR Operations
kstruckhoff@ebay.com ebayenterprise.com
o: 818.686.4719 | c: 818.968.0634 |
The information contained in this electronic mail transmission is intended only for the use of the individual or entity named in this transmission. If you are not the intended recipient of this transmission, you are hereby notified that any disclosure, copying or distribution of the contents of this transmission is strictly prohibited and that you should delete the contents of this transmission from your system immediately. Any comments or statements contained in this transmission do not necessarily reflect the views or position of eBay Enterprise or its subsidiaries and/or affiliates.
-----Original Message-----
From: Kevin Grittner [mailto:kgrittn@ymail.com]
Sent: Wednesday, July 10, 2013 3:25 PM
To: Struckhoff, Kevin; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Connecting to a remote db server
"Struckhoff, Kevin" <kstruckhoff@ebay.com> wrote:
> I've installed postgres 9.2 on a server, call it db01. I now want
> to access postgres from my app server, call it app01.
>
> What do I install on the app01 server? I've installed postgres
> 9.2 on it and set the postgresesql.conf file's listen_address to
> a value of '*' on both machines. I've also modified the
> pg_hba.conf file to be wide open for now on both machines.
The postgresesql.conf and pg_hba.conf files aren't used on the
client side -- those only matter on the server.
> It seems that something else is missing or needs to be done.
> Googling wasn't much help, the results weren't current.
How are you trying to connect, and what happens when you try?
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Connecting to a remote db server
@ 2013-07-10 22:41 Alvaro Herrera <alvherre@2ndquadrant.com>
parent: Struckhoff, Kevin <kstruckhoff@ebay.com>
0 siblings, 0 replies; 12+ messages in thread
From: Alvaro Herrera @ 2013-07-10 22:41 UTC (permalink / raw)
To: Struckhoff, Kevin <kstruckhoff@ebay.com>; +Cc: pgsql-admin
Struckhoff, Kevin wrote:
> Sorry, rhel 5.8. so there is a separate client install package?
Yes; on RHEL the library package is called postgresql-libs or something
similar, while the client package containing the psql utility is just
"postgresql". (The server lives in a package called postgresql-server).
This site might be helpful: http://yum.postgresql.org/
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Connecting to a remote db server
@ 2013-07-10 23:06 Alvaro Herrera <alvherre@2ndquadrant.com>
parent: Struckhoff, Kevin <kstruckhoff@ebay.com>
1 sibling, 2 replies; 12+ messages in thread
From: Alvaro Herrera @ 2013-07-10 23:06 UTC (permalink / raw)
To: Struckhoff, Kevin <kstruckhoff@ebay.com>; +Cc: Kevin Grittner <kgrittn@ymail.com>; pgsql-admin
Struckhoff, Kevin wrote:
> I'm trying to use the psql tool:
>
> /home/postgres->psql test
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> the answer of course is No..
Oh, well, you need to specify the hostname or address of the remote server:
psql -h db01 test
Otherwise, it's just trying to connect to localhost, as you've seen.
You might need to adjust pg_hba.conf on the db01 server to allow
connections from your app01 client host.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Connecting to a remote db server
@ 2013-07-10 23:19 javmendez1@gmail.com
parent: Alvaro Herrera <alvherre@2ndquadrant.com>
1 sibling, 1 reply; 12+ messages in thread
From: javmendez1@gmail.com @ 2013-07-10 23:19 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@2ndquadrant.com>; pgsql-admin-owner@postgresql.org, "Struckhoff, Kevin" <kstruckhoff@ebay.com>; +Cc: Kevin Grittner <kgrittn@ymail.com>; pgsql-admin
Review the postgresql.conf and chek the "listen_adress" parameter.
listen_adress="localhost"
Change localhost by *
Example: listen_adress="*"
Este mensaje ha sido enviado gracias al servicio BlackBerry de Movilnet
-----Original Message-----
From: Alvaro Herrera <alvherre@2ndquadrant.com>
Sender: pgsql-admin-owner@postgresql.orgDate: Wed, 10 Jul 2013 19:06:23
To: Struckhoff, Kevin<kstruckhoff@ebay.com>
Cc: Kevin Grittner<kgrittn@ymail.com>; pgsql-admin@postgresql.org<pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Connecting to a remote db server
Struckhoff, Kevin wrote:
> I'm trying to use the psql tool:
>
> /home/postgres->psql test
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> the answer of course is No..
Oh, well, you need to specify the hostname or address of the remote server:
psql -h db01 test
Otherwise, it's just trying to connect to localhost, as you've seen.
You might need to adjust pg_hba.conf on the db01 server to allow
connections from your app01 client host.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Connecting to a remote db server
@ 2013-07-10 23:45 Struckhoff, Kevin <kstruckhoff@ebay.com>
parent: javmendez1@gmail.com
0 siblings, 1 reply; 12+ messages in thread
From: Struckhoff, Kevin @ 2013-07-10 23:45 UTC (permalink / raw)
To: javmendez1@gmail.com <javmendez1@gmail.com>; Alvaro Herrera <alvherre@2ndquadrant.com>; pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org>; +Cc: Kevin Grittner <kgrittn@ymail.com>; pgsql-admin
I already did that. In fact, it works fine for pgAdmin III access from my laptop to my db server.
Kevin Struckhoff, TDWI
Sr. IT Mgr, LA DR Operations
kstruckhoff@ebay.com ebayenterprise.com
o: 818.686.4719 | c: 818.968.0634 |
The information contained in this electronic mail transmission is intended only for the use of the individual or entity named in this transmission. If you are not the intended recipient of this transmission, you are hereby notified that any disclosure, copying or distribution of the contents of this transmission is strictly prohibited and that you should delete the contents of this transmission from your system immediately. Any comments or statements contained in this transmission do not necessarily reflect the views or position of eBay Enterprise or its subsidiaries and/or affiliates.
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of javmendez1@gmail.com
Sent: Wednesday, July 10, 2013 4:19 PM
To: Alvaro Herrera; pgsql-admin-owner@postgresql.org; Struckhoff, Kevin
Cc: Kevin Grittner; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Connecting to a remote db server
Review the postgresql.conf and chek the "listen_adress" parameter.
listen_adress="localhost"
Change localhost by *
Example: listen_adress="*"
Este mensaje ha sido enviado gracias al servicio BlackBerry de Movilnet
-----Original Message-----
From: Alvaro Herrera <alvherre@2ndquadrant.com>
Sender: pgsql-admin-owner@postgresql.orgDate: Wed, 10 Jul 2013 19:06:23
To: Struckhoff, Kevin<kstruckhoff@ebay.com>
Cc: Kevin Grittner<kgrittn@ymail.com>; pgsql-admin@postgresql.org<pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Connecting to a remote db server
Struckhoff, Kevin wrote:
> I'm trying to use the psql tool:
>
> /home/postgres->psql test
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> the answer of course is No..
Oh, well, you need to specify the hostname or address of the remote server:
psql -h db01 test
Otherwise, it's just trying to connect to localhost, as you've seen.
You might need to adjust pg_hba.conf on the db01 server to allow
connections from your app01 client host.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Connecting to a remote db server
@ 2013-07-10 23:50 javmendez1@gmail.com
parent: Struckhoff, Kevin <kstruckhoff@ebay.com>
0 siblings, 0 replies; 12+ messages in thread
From: javmendez1@gmail.com @ 2013-07-10 23:50 UTC (permalink / raw)
To: Struckhoff, Kevin <kstruckhoff@ebay.com>; Alvaro Herrera <alvherre@2ndquadrant.com>; pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org>; +Cc: Kevin Grittner <kgrittn@ymail.com>; pgsql-admin
Ok, the aplication server and your laptop have the IP adress in the same subnet ?
Este mensaje ha sido enviado gracias al servicio BlackBerry de Movilnet
-----Original Message-----
From: "Struckhoff, Kevin" <kstruckhoff@ebay.com>
Date: Wed, 10 Jul 2013 23:45:01
To: javmendez1@gmail.com<javmendez1@gmail.com>; Alvaro Herrera<alvherre@2ndquadrant.com>; pgsql-admin-owner@postgresql.org<pgsql-admin-owner@postgresql.org>
Cc: Kevin Grittner<kgrittn@ymail.com>; pgsql-admin@postgresql.org<pgsql-admin@postgresql.org>
Subject: RE: [ADMIN] Connecting to a remote db server
I already did that. In fact, it works fine for pgAdmin III access from my laptop to my db server.
Kevin Struckhoff, TDWI
Sr. IT Mgr, LA DR Operations
kstruckhoff@ebay.com ebayenterprise.com
o: 818.686.4719 | c: 818.968.0634 |
The information contained in this electronic mail transmission is intended only for the use of the individual or entity named in this transmission. If you are not the intended recipient of this transmission, you are hereby notified that any disclosure, copying or distribution of the contents of this transmission is strictly prohibited and that you should delete the contents of this transmission from your system immediately. Any comments or statements contained in this transmission do not necessarily reflect the views or position of eBay Enterprise or its subsidiaries and/or affiliates.
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of javmendez1@gmail.com
Sent: Wednesday, July 10, 2013 4:19 PM
To: Alvaro Herrera; pgsql-admin-owner@postgresql.org; Struckhoff, Kevin
Cc: Kevin Grittner; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Connecting to a remote db server
Review the postgresql.conf and chek the "listen_adress" parameter.
listen_adress="localhost"
Change localhost by *
Example: listen_adress="*"
Este mensaje ha sido enviado gracias al servicio BlackBerry de Movilnet
-----Original Message-----
From: Alvaro Herrera <alvherre@2ndquadrant.com>
Sender: pgsql-admin-owner@postgresql.orgDate: Wed, 10 Jul 2013 19:06:23
To: Struckhoff, Kevin<kstruckhoff@ebay.com>
Cc: Kevin Grittner<kgrittn@ymail.com>; pgsql-admin@postgresql.org<pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Connecting to a remote db server
Struckhoff, Kevin wrote:
> I'm trying to use the psql tool:
>
> /home/postgres->psql test
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> the answer of course is No..
Oh, well, you need to specify the hostname or address of the remote server:
psql -h db01 test
Otherwise, it's just trying to connect to localhost, as you've seen.
You might need to adjust pg_hba.conf on the db01 server to allow
connections from your app01 client host.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Connecting to a remote db server
@ 2013-07-11 00:00 Struckhoff, Kevin <kstruckhoff@ebay.com>
parent: Alvaro Herrera <alvherre@2ndquadrant.com>
1 sibling, 0 replies; 12+ messages in thread
From: Struckhoff, Kevin @ 2013-07-11 00:00 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@2ndquadrant.com>; +Cc: pgsql-admin
Thanks Alvaro, that works. Appreciate the help.
Kevin Struckhoff, TDWI
Sr. IT Mgr, LA DR Operations
kstruckhoff@ebay.com ebayenterprise.com
o: 818.686.4719 | c: 818.968.0634 |
The information contained in this electronic mail transmission is intended only for the use of the individual or entity named in this transmission. If you are not the intended recipient of this transmission, you are hereby notified that any disclosure, copying or distribution of the contents of this transmission is strictly prohibited and that you should delete the contents of this transmission from your system immediately. Any comments or statements contained in this transmission do not necessarily reflect the views or position of eBay Enterprise or its subsidiaries and/or affiliates.
-----Original Message-----
From: Alvaro Herrera [mailto:alvherre@2ndquadrant.com]
Sent: Wednesday, July 10, 2013 4:06 PM
To: Struckhoff, Kevin
Cc: Kevin Grittner; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Connecting to a remote db server
Struckhoff, Kevin wrote:
> I'm trying to use the psql tool:
>
> /home/postgres->psql test
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> the answer of course is No..
Oh, well, you need to specify the hostname or address of the remote server:
psql -h db01 test
Otherwise, it's just trying to connect to localhost, as you've seen.
You might need to adjust pg_hba.conf on the db01 server to allow
connections from your app01 client host.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Connecting to a remote db server
@ 2013-07-11 03:37 Kevin Grittner <kgrittn@ymail.com>
parent: Struckhoff, Kevin <kstruckhoff@ebay.com>
1 sibling, 0 replies; 12+ messages in thread
From: Kevin Grittner @ 2013-07-11 03:37 UTC (permalink / raw)
To: Struckhoff, Kevin <kstruckhoff@ebay.com>; pgsql-admin
"Struckhoff, Kevin" <kstruckhoff@ebay.com> wrote:
> From: Kevin Grittner [mailto:kgrittn@ymail.com]
>> "Struckhoff, Kevin" <kstruckhoff@ebay.com> wrote:
>>> I've installed postgres 9.2 on a server, call it db01. I now want
>>> to access postgres from my app server, call it app01.
>>> It seems that something else is missing or needs to be done.
>> How are you trying to connect, and what happens when you try?
> I'm trying to use the psql tool:
>
> /home/postgres->psql test
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Since you didn't specify a host, it's looking on your local
machine. What happens if you run?:
psql -h app01 test
You can look at the connection options by running:
psql --help
... or by reading the docs:
http://www.postgresql.org/docs/current/interactive/app-psql.html
... or by using the man page, if available.
By the way, I believe that most server distributions include all
the client software, but you could probably find a client-only
package on most platforms.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2013-07-11 03:37 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-07-10 21:58 Connecting to a remote db server Struckhoff, Kevin <kstruckhoff@ebay.com>
2013-07-10 22:22 ` Alvaro Herrera <alvherre@2ndquadrant.com>
2013-07-10 22:27 ` Struckhoff, Kevin <kstruckhoff@ebay.com>
2013-07-10 22:41 ` Alvaro Herrera <alvherre@2ndquadrant.com>
2013-07-10 22:24 ` Kevin Grittner <kgrittn@ymail.com>
2013-07-10 22:33 ` Struckhoff, Kevin <kstruckhoff@ebay.com>
2013-07-10 23:06 ` Alvaro Herrera <alvherre@2ndquadrant.com>
2013-07-10 23:19 ` javmendez1@gmail.com
2013-07-10 23:45 ` Struckhoff, Kevin <kstruckhoff@ebay.com>
2013-07-10 23:50 ` javmendez1@gmail.com
2013-07-11 00:00 ` Struckhoff, Kevin <kstruckhoff@ebay.com>
2013-07-11 03:37 ` Kevin Grittner <kgrittn@ymail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox