Skip site navigation (1) Skip section navigation (2)

Re: Ubuntu: Start and Stop

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Sidar López Cruz <sidarlopez(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Ubuntu: Start and Stop
Date: 2006-03-31 16:07:51
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
Sidar López Cruz wrote:
> How to start and stop automatically PostgreSQL over Ubuntu when  
> postgres user have password.
> I'd try with su - postgres but this fails because it request me the 
> password

You would be better served to use #ubuntu on

However in answer to your question... use:

sudo su -

Which will ask you for your standard user password. Then:

/etc/init.d/postgresql (or /etc/init.d/postgresql8) stop/start


Joshua D. Drake

> Please help....
> _________________________________________________________________
> Charla con tus amigos en línea mediante MSN Messenger: 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match


             === The PostgreSQL Company: Command Prompt, Inc. ===
       Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
       Providing the most comprehensive  PostgreSQL solutions since 1997

In response to


pgsql-admin by date

Next:From: Tom LaneDate: 2006-03-31 16:19:27
Subject: Re: Ubuntu: Start and Stop
Previous:From: Sidar López CruzDate: 2006-03-31 15:32:36
Subject: Ubuntu: Start and Stop

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group