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@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