Re: role does not exist - Mailing list pgsql-general

From Kevin Burton
Subject Re: role does not exist
Date
Msg-id 008301cdb839$4da15dc0$e8e41940$@charter.net
Whole thread Raw
In response to Re: role does not exist  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: role does not exist  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
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@gmail.com]
Sent: Thursday, November 01, 2012 8:52 AM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgsql-general@postgresql.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.klaver@gmail.com]
> Sent: Thursday, November 01, 2012 8:42 AM
> To: Kevin Burton
> Cc: 'Joshua D. Drake'; pgsql-general@postgresql.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.klaver@gmail.com
>>
>>
>
>


--
Adrian Klaver
adrian.klaver@gmail.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: role does not exist
Next
From: craig@gtek.biz
Date:
Subject: Re: Unable to do a mailing list proper search