Re: error: connection to server on socket...

Thank you Adrian. It Worked!!! On 8/1/23 2:55 p.m., Adrian Klaver wrote: On 8/1/23 11:42, Amn Ojee Uw wrote: Ah! Adrean, here is something interesting. /*pg_lsclusters*/ displays the following information /*Ver Cluster Port Status    Owner    Data directory  Log

Re: PostgreSQL listens on localhost?

Hi Adrian, I have just started with PostgreSQL after years away from Micro$oft SQL Server. Thank you very much for the quick reference as I have also been trying to get through the documentation (all 3063 pages of it!). FDG On Tue, Aug 1, 2023 at 11:42 AM Adrian Klaver wrote: > On 8/1/23

Re: error: connection to server on socket...

On 8/1/23 11:42, Amn Ojee Uw wrote: Ah! Adrean, here is something interesting. /*pg_lsclusters*/ displays the following information /*Ver Cluster Port Status    Owner    Data directory  Log file*//* *//*12  main    5432 down,binaries_missing postgres

Re: PostgreSQL listens on localhost?

On 8/1/23 09:12, Frank Gunseor wrote: I have read that PostgreSQL listens on localhost is it possible to have it listen on an IP address? Read: https://www.postgresql.org/docs/current/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS Thank you. FDG -- Adrian Klaver

Re: error: connection to server on socket...

Ah! Adrean, here is something interesting. /*pg_lsclusters*/ displays the following information /*Ver Cluster Port Status    Owner    Data directory  Log file*//* *//*12  main    5432 down,binaries_missing postgres /var/lib/postgresql/12/main

Re: Sample pg_hba.conf allows local users to access all databases

On Tue, Aug 1, 2023 at 10:13 AM William Edwards wrote: > This allows all local users connecting over TCP to access all databases, > not only the databases that the user is a member of as one might expect. > > Proof that user is able to access database that it is not a member of is > below.

Re: Sample pg_hba.conf allows local users to access all databases

> On Aug 1, 2023, at 10:13, William Edwards wrote: > This allows all local users connecting over TCP to access all databases, not > only the databases that the user is a member of as one might expect. There's really no notion of a user being "a member of" a database in PostgreSQL. Users

Re: How to build a new grammer for pg?

On Tue, Aug 1, 2023 at 2:27 AM jacktby wrote: > Hi, I’m trying to develop a new grammar for pg, can you give me a code > example to reference? > Use git blame or a repo history viewer. David J.

Sample pg_hba.conf allows local users to access all databases

Hi, The sample pg_hba.conf in master (https://github.com/postgres/postgres/blob/master/src/backend/libpq/pg_hba.conf.sample) contains the following lines: ``` # IPv4 local connections: hostall all 127.0.0.1/32 @authmethodhost@ # IPv6 local

Re: PostgreSQL listens on localhost?

On 8/1/23 11:12, Frank Gunseor wrote: I have read that PostgreSQL listens on localhost is it possible to have it listen on an IP address? Of course.  "localhost" is just the default. -- Born in Arizona, moved to Babylonia.

Re: PostgreSQL listens on localhost?

El día martes, agosto 01, 2023 a las 09:12:51a. m. -0700, Frank Gunseor escribió: > I have read that PostgreSQL listens on localhost is it possible to have it > listen on an IP address? > > Thank you. > > FDG How about reading the man page of postgresql.conf and pg_hba.conf Thanks

PostgreSQL listens on localhost?

I have read that PostgreSQL listens on localhost is it possible to have it listen on an IP address? Thank you. FDG

Re:How to build a new grammer for pg?

If you want to add some new function to postgresql, just check this ducument: https://www.postgresql.org/docs/current/extend-how.html --Original-- From:

Re: error: connection to server on socket...

On 8/1/23 03:22, Amn Ojee Uw wrote: Using the following command on my Debian 12 machine: /*sudo apt-get install postgresql postgresql-15 postgresql-client-common postgresql-common postgresql-contrib postgresql-doc phppgadmin */ and following the instruction on this

Re: PORT 5432 ERROR

On 7/31/23 16:18, David Beck wrote: I am receiving an error when I enter the server port number to listen to—installed on all available versions, both 32-bit and 64-bit when applicable, even the latest version, 15.3 x64 for Windows. I downloaded the latest version as an example, and as I was

Re: error: connection to server on socket...

p...@pfortin.com writes: > On Tue, 1 Aug 2023 06:22:46 -0400 Amn Ojee Uw wrote: >> "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory*//* > Like mine, your distro probably uses /tmp/.s.PGSQL.5432 > $ ll /tmp/.s.PGSQL.5432 > srwxrwxrwx 1 postgres postgres 0 Aug 1 06:33

Re: error: connection to server on socket...

El día martes, agosto 01, 2023 a las 07:28:49 -0400, p...@pfortin.com escribió: > On Tue, 1 Aug 2023 06:22:46 -0400 Amn Ojee Uw wrote: > > >"/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory*//* > > Like mine, your distro probably uses /tmp/.s.PGSQL.5432 > $ ll

Re: error: connection to server on socket...

On Tue, 1 Aug 2023 06:22:46 -0400 Amn Ojee Uw wrote: >"/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory*//* Like mine, your distro probably uses /tmp/.s.PGSQL.5432 $ ll /tmp/.s.PGSQL.5432 srwxrwxrwx 1 postgres postgres 0 Aug 1 06:33 /tmp/.s.PGSQL.5432=

Re: PORT 5432 ERROR

On 01.08.23 01:18, David Beck wrote: I am receiving an error when I enter the server port number to listen to—installed on all available versions, both 32-bit and 64-bit when applicable, even the latest version, 15.3 x64 for Windows. I downloaded the latest version as an example, and as I was

Re: error: connection to server on socket...

On 01.08.23 12:22, Amn Ojee Uw wrote: Using the following command on my Debian 12 machine: sudo apt-get install postgresql postgresql-15 postgresql-client-common postgresql-common postgresql-contrib postgresql-doc phppgadmin and following the instruction on this

Re: error: connection to server on socket...

_*Addendum*_ I tried this, but to no avail : /*sudo systemctl start postgresql*/ On 8/1/23 6:22 a.m., Amn Ojee Uw wrote: Using the following command on my Debian 12 machine: /*sudo apt-get install postgresql postgresql-15 postgresql-client-common postgresql-common postgresql-contrib

error: connection to server on socket...

Using the following command on my Debian 12 machine: /*sudo apt-get install postgresql postgresql-15 postgresql-client-common postgresql-common postgresql-contrib postgresql-doc phppgadmin */ and following the instruction on this web page I

How to build a new grammer for pg?

Hi, I’m trying to develop a new grammar for pg, can you give me a code example to reference?

PORT 5432 ERROR

I am receiving an error when I enter the server port number to listen to—installed on all available versions, both 32-bit and 64-bit when applicable, even the latest version, 15.3 x64 for Windows. I downloaded the latest version as an example, and as I was told, I used the 5432 port as the default