Re: Ubuntu: Start and Stop

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 chat.us.freenode.net.

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

Sincerely,

Joshua D. Drake

>
> Please help....
>
> _________________________________________________________________
> Charla con tus amigos en línea mediante MSN Messenger:
> http://messenger.latam.msn.com/
>
>
> ---------------------------(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
http://www.commandprompt.com/