Re: [ADMIN] Connecting to a remote db server

2013-07-11 Thread Struckhoff, Kevin
...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of javmend...@gmail.com Sent: Wednesday, July 10, 2013 4:19 PM To: Alvaro Herrera; pgsql-admin-ow...@postgresql.org; Struckhoff, Kevin Cc: Kevin Grittner; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Connecting to a remote db server

Re: [ADMIN] Connecting to a remote db server

2013-07-11 Thread Struckhoff, Kevin
, 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 su

Re: [ADMIN] Connecting to a remote db server

2013-07-10 Thread Kevin Grittner
"Struckhoff, Kevin" wrote: > From: Kevin Grittner [mailto:kgri...@ymail.com] >> "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. >>> It seems that something else is missing or needs to be d

Re: [ADMIN] Connecting to a remote db server

2013-07-10 Thread javmendez1
ra; pgsql-admin-ow...@postgresql.org Cc: Kevin Grittner; 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

Re: [ADMIN] Connecting to a remote db server

2013-07-10 Thread javmendez1
era Sender: pgsql-admin-owner@postgresql.orgDate: Wed, 10 Jul 2013 19:06:23 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->ps

Re: [ADMIN] Connecting to a remote db server

2013-07-10 Thread Alvaro Herrera
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

Re: [ADMIN] Connecting to a remote db server

2013-07-10 Thread Struckhoff, Kevin
ubject: 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 postgre

Re: [ADMIN] Connecting to a remote db server

2013-07-10 Thread Struckhoff, Kevin
: 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. &

Re: [ADMIN] Connecting to a remote db server

2013-07-10 Thread Alvaro Herrera
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-

Re: [ADMIN] Connecting to a remote db server

2013-07-10 Thread Kevin Grittner
"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 o

Re: [ADMIN] Connecting to a remote db server

2013-07-10 Thread Alvaro Herrera
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 '*

[ADMIN] Connecting to a remote db server

2013-07-10 Thread Struckhoff, Kevin
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 modi