Re: help

On 17/01/2020 10:00, Kaab Rustam wrote:
> What platform?
> MacOS Catalina 10.15.3 Beta (19D62e)
>
> - How did you install PostgreSQL?
>
> I installed it downloading Postgres from their web, and ticked pgadmin 4
> during installation
>
> - Are you trying to connect from the same machine on which PG is
> installed, or from another machine?
>
>
> same machine 
> I'd also check a couple of things:
>
> - Is PostgreSQL running? Look for PG processes:
>
>   ps ax | grep postgres
>
> here is the result
> (
>
>  ps ax | grep postgres
>
>  1587   ??  Ss     0:01.70 postgres: logger    
>
>  1589   ??  Ss     0:00.67 postgres: checkpointer    
>
> 11377 s002  S+     0:00.00 grep postgres)

Hi there,

Please reply to the list as well as to me - "Reply-all" should do the job.

I'm not an expert, but I'd have expected to see more processes than
that... here's what I see (Debian 9, with both 11 and 12 installed):

717 ? Ss 0:00 /usr/lib/postgresql/12/bin/postgres -D
/var/lib/postgresql/12/main -c
config_file=/etc/postgresql/12/main/postgresql.conf
718 ? S 0:00 /usr/lib/postgresql/11/bin/postgres -D
/var/lib/postgresql/11/main -c
config_file=/etc/postgresql/11/main/postgresql.conf
738 ? Ss 0:00 postgres: 12/main: checkpointer
739 ? Ss 0:00 postgres: 12/main: background writer
740 ? Ss 0:00 postgres: 12/main: walwriter
741 ? Ss 0:00 postgres: 12/main: autovacuum launcher
742 ? Ss 0:00 postgres: 12/main: stats collector
743 ? Ss 0:00 postgres: 12/main: logical replication
launcher
745 ? Ss 0:00 postgres: 11/main: checkpointer
746 ? Ss 0:00 postgres: 11/main: background writer
747 ? Ss 0:00 postgres: 11/main: walwriter
748 ? Ss 0:00 postgres: 11/main: autovacuum launcher
749 ? Ss 0:00 postgres: 11/main: stats collector
750 ? Ss 0:00 postgres: 11/main: logical replication
launcher
7038 pts/1 S+ 0:00 grep postgres

Ray.

--
Raymond O'Donnell // Galway // Ireland
ray(at)rodonnell(dot)ie