I do see actually three lines with a -D in it that may be similar: 1166 ? S 0:01 /usr/bin/postgres -C -D /var/lib/postgres-xc/coord 1214 ? S 0:01 /usr/bin/postgres -X -D /var/lib/postgres-xc/datanode1 1233 ? S 0:01 /usr/bin/postgres -X -D /var/lib/postgres-xc/datanode2 There are a number of entries of the form: 1185 ? Ss 0:10 postgres: pooler process -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxx] Sent: Thursday, November 01, 2012 8:52 AM To: Kevin Burton Cc: 'Joshua D. Drake'; pgsql-general@xxxxxxxxxxxxxx Subject: Re: role does not exist On 11/01/2012 06:45 AM, Kevin Burton wrote: > I am having a hard time with the clipboard so I will reproduce the > output as best as I can: > > 2066 tty1 S+ 0:00 grep --color=auto postgresql So Postgres is not actually running. What you are seeing is the grep command. If it where running you would see something like: 29041 ? S 0:01 /usr/lib/postgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c config_file=/etc/postgresql/8.4/main/postgresql.conf Try: sudo /etc/init.d/postgresql-9.1 start This should start Postgres. Then do: sudo -u postgres psql > > > -----Original Message----- > From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxx] > Sent: Thursday, November 01, 2012 8:42 AM > To: Kevin Burton > Cc: 'Joshua D. Drake'; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: role does not exist > > On 11/01/2012 06:38 AM, Kevin Burton wrote: >> Dpkg -l | grep postgresql shows >> postgresql-9.1 >> postgresql-common >> postgresql-client-common >> postgresql-doc >> postgresql-doc-9.1 >> Ps -ax | grep postgresql shows >> Postgresql > > Please show the actual output from the ps command. > > >> >> -- >> Adrian Klaver >> adrian.klaver@xxxxxxxxx >> >> > > -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
