Re: role does not exist

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(dot)klaver(at)gmail(dot)com]
Sent: Thursday, November 01, 2012 8:52 AM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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(dot)klaver(at)gmail(dot)com]
> Sent: Thursday, November 01, 2012 8:42 AM
> To: Kevin Burton
> Cc: 'Joshua D. Drake'; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] 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(dot)klaver(at)gmail(dot)com
>>
>>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com