Обсуждение: how to connect pgadmin III to postgresql 9.1.3 in ubuntu local computer?
I have install postgresql and pgadminm via ubuntu software center but unable to connect to postgresql by pgadmin.
i get error connection failed.Re: how to connect pgadmin III to postgresql 9.1.3 in ubuntu local computer?
От
David G Johnston
Дата:
Emmanuel Massawe wrote > I have install postgresql and pgadminm via ubuntu software center but > unable to connect to postgresql by pgadmin. > > i get error connection failed. Try "psql". If that works its something to do with pgAdmin itself. If it doesn't then something with the server process is mis-configured. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-connect-pgadmin-III-to-postgresql-9-1-3-in-ubuntu-local-computer-tp5811603p5811610.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Re: how to connect pgadmin III to postgresql 9.1.3 in ubuntu local computer?
От
"Gilberto Castillo"
Дата:
> I have install postgresql and pgadminm via ubuntu software center but > unable to connect to postgresql by pgadmin. > > i get error connection failed. What you error? Saludos, Gilberto Castillo La Habana, Cuba --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
Hi Emmanuel, Probably your postgresql instance is not listening to external devices. Check your postgresql.conf file. By default it listen only to the localhost listen_addresses = 'localhost' Check, as well, the pg_hba.conf grants. Iñigo El 15/07/14 16:25, Emmanuel Massawe escribió: > I have install postgresql and pgadminm via ubuntu software center but > unable to connect to postgresql by pgadmin. > > i get error connection failed. > >
Re: Re: how to connect pgadmin III to postgresql 9.1.3 in ubuntu local computer?
От
David Johnston
Дата:
You need to reply to the list, not me personally. You should also bottom-post like I did in my response to you.
You also need to provide more detail on your exact setup. How and where did you run psql and how and where are you running pgAdmin?
Typically I find "Broken Pipe" occurring because you are SSH'ing into the remote machine and you SSH connect gets dropped. This is not the fault or responsibility of PostgreSQL.
David J.
On Wed, Jul 16, 2014 at 2:55 AM, Emmanuel Massawe <furiandesuo@gmail.com> wrote:
Error connecting to the server: server closed the connection unexpectedlycould not send startup packet: Broken pipe
This probably means the server terminated abnormally
before or while processing the request.On Wed, Jul 16, 2014 at 9:52 AM, Emmanuel Massawe <furiandesuo@gmail.com> wrote:Error connecting to the server: server closed the connection unexpectedly
This probably means the server terminated abnormally before or while processing the request.
On Wed, Jul 16, 2014 at 8:47 AM, Emmanuel Massawe <furiandesuo@gmail.com> wrote:psql works well, but when i want to use pgadmin to connect to postgresql error occurOn Tue, Jul 15, 2014 at 5:48 PM, David G Johnston <david.g.johnston@gmail.com> wrote:Emmanuel Massawe wrote> I have install postgresql and pgadminm via ubuntu software center butTry "psql". If that works its something to do with pgAdmin itself. If it
> unable to connect to postgresql by pgadmin.
>
> i get error connection failed.
doesn't then something with the server process is mis-configured.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-connect-pgadmin-III-to-postgresql-9-1-3-in-ubuntu-local-computer-tp5811603p5811610.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin