Thread: i need help

On 11/02/2021 15:53, Ralf Bezzenberger wrote:
> Hallo,
> 
> I am using pgAdmin 4.30 and have the following problem:
> 
> I had a server running and then removed it. When trying to add a new 
> server with the same name I get the message that localhost:5432 cannot 
> be connected (see Attachment).
> 
> Using netstat tell me there is no process on that port.

Is the PostgreSQL server on localhost or on a remote machine?

If it's localhost, check the port which it's listening on - it might be 
something other than 5432. You should find this in postgresql.conf.

Ray.

-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

On 11/02/2021 16:22, Ralf Bezzenberger wrote:
> I am on localhost and I don't find postgresql.conf.

Please send your replies to the list - "Reply-all" will do this.

I haven't used Windows in a long time, so I don't know where to look for 
postgresql.conf... others here will be able to advise.


Ray.

-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

Am 11.02.2021 um 17:34 schrieb Ray O'Donnell:
> On 11/02/2021 16:22, Ralf Bezzenberger wrote:
>> I am on localhost and I don't find postgresql.conf.
>
> Please send your replies to the list - "Reply-all" will do this.
>
> I haven't used Windows in a long time, so I don't know where to look for
> postgresql.conf... others here will be able to advise.
>
Should be C:\Program Files\PostgreSQL\<Version number>\data - but I
suppose that could be changed at installation. But: looking into that
directory needs admin rights - and searching for the file name with the
Windows Explorer only finds postgresql.conf.sample in
C:\Program Files\PostgreSQL\<Version number>\share.

That might explain why you couldn't easily find the file.

HTH
Sibylle

I am on localhost and I don't find postgresql.conf.

Mit freundlichen Grüßen,
 
Dr. Ralf Bezzenberger

Senior IT Consultant
New Data Solutions
Consumer Products
 
msg systems ag
Robert-Bürkle-Str. 1
85737 Ismaning
Deutschland

Mobil: +49 1511 7488310
E-Mail: ralf.bezzenberger@msg.group

http://www.msg.group
 
Sitz der Gesellschaft: 85737 Ismaning/München
Vorstand: Dr. Stephan Frohnhoff (Vorsitzender), Rolf Kranz, Bernhard Lang, Dr. Aristid Neuburger, Karsten Redenius, Dr.
FrankSchlottmann, Dr. Jürgen Zehetmaier 
Aufsichtsratsvorsitzender: Johann Zehetmaier
Handelsregister: Amtsgericht München, HRB 140 149

Bitte beachten Sie, dass der Inhalt dieser E-Mail vertraulich zu behandeln ist. Sofern Sie nicht der beabsichtigte
Adressatsind, dürfen wir Sie bitten, uns umgehend zu benachrichtigen und den Inhalt dieser E-Mail zu löschen.  


-----Ursprüngliche Nachricht-----
Von: Ray O'Donnell <ray@rodonnell.ie>
Gesendet: Donnerstag, 11. Februar 2021 17:13
An: Ralf Bezzenberger <Ralf.Bezzenberger@msg.group>; pgadmin-support@lists.postgresql.org
Betreff: Re: i need help

On 11/02/2021 15:53, Ralf Bezzenberger wrote:
> Hallo,
>
> I am using pgAdmin 4.30 and have the following problem:
>
> I had a server running and then removed it. When trying to add a new
> server with the same name I get the message that localhost:5432 cannot
> be connected (see Attachment).
>
> Using netstat tell me there is no process on that port.

Is the PostgreSQL server on localhost or on a remote machine?

If it's localhost, check the port which it's listening on - it might be something other than 5432. You should find this
inpostgresql.conf. 

Ray.

--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie