| From: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> |
|---|---|
| To: | Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com> |
| Cc: | "pgsql-performance-owner(at)postgresql(dot)org" <pgsql-performance-owner(at)postgresql(dot)org>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: PGadmin error while connecting with database. |
| Date: | 2018-01-12 08:44:31 |
| Message-ID: | CA+t6e1m+wnQzzF7kNQgwPCQHDkZGUEiN6UrExsZcr5Vipcjwig@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Do you any errors in the server log or in the log of pgadmin (show us..)?
What are the settings that you configured for your pgadmin client and for
the connection ?
2018-01-12 6:55 GMT+02:00 Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com>:
> Dear Expert,
>
>
>
> While connecting PostgreSQL 9.3 with PGAdmin client I am getting the below
> error.
>
>
>
>
>
> However I am able to connect the database using psql thourgh Putty.
>
>
>
> *Entry in pg_hba.conf*
>
>
>
> # IPv4 local connections:
>
> host all all 127.0.0.1/32 md5
>
> host all all 0.0.0.0/0 md5
>
>
>
> *entry in Postgresql.conf*
>
>
>
> listen_addresses = '*'
>
> port = 5432
>
>
>
> port is already open and I am able to telnet.
>
>
>
> Even after creating a new instance and fresh installation of PostgreSQL, I
> am getting the same error.
>
>
>
> OS-CentOS 7
>
> S/w-PostgreSQL9.3
>
>
>
> *Regards,*
>
> *Dinesh Chandra*
>
> *|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.*
>
> *------------------------------------------------------------------*
>
> Mobile: +91-9953975849 | Ext 1078 |dinesh(dot)chandra(at)cyient(dot)com
>
> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India
> <https://maps.google.com/?q=NSEZ,+Phase-II+,Noida-Dadri+Road,+Noida+-+201+305,India&entry=gmail&source=g>
> .
>
>
>
> ------------------------------
>
> DISCLAIMER:
>
> This email message is for the sole use of the intended recipient(s) and
> may contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not the
> intended recipient, please contact the sender by reply email and destroy
> all copies of the original message. Check all attachments for viruses
> before opening them. All views or opinions presented in this e-mail are
> those of the author and may not reflect the opinion of Cyient or those of
> our affiliates.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2018-01-12 10:04:42 | Re: Query is slow when run for first time; subsequent execution is fast |
| Previous Message | Nandakumar M | 2018-01-12 08:03:32 | Re: Query is slow when run for first time; subsequent execution is fast |