pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUbuntu: Start and Stop
5+ messages / 4 participants
[nested] [flat]
* Ubuntu: Start and Stop
@ 2006-03-31 15:32 Sidar López Cruz <sidarlopez@hotmail.com>
2006-03-31 16:07 ` Re: Ubuntu: Start and Stop Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 5+ messages in thread
From: Sidar López Cruz @ 2006-03-31 15:32 UTC (permalink / raw)
To: pgsql-admin
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
Please help....
_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.latam.msn.com/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Ubuntu: Start and Stop
2006-03-31 15:32 Ubuntu: Start and Stop Sidar López Cruz <sidarlopez@hotmail.com>
@ 2006-03-31 16:07 ` Joshua D. Drake <jd@commandprompt.com>
2006-03-31 16:19 ` Re: Ubuntu: Start and Stop Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Joshua D. Drake @ 2006-03-31 16:07 UTC (permalink / raw)
To: Sidar López Cruz <sidarlopez@hotmail.com>; +Cc: 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 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/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Ubuntu: Start and Stop
2006-03-31 15:32 Ubuntu: Start and Stop Sidar López Cruz <sidarlopez@hotmail.com>
2006-03-31 16:07 ` Re: Ubuntu: Start and Stop Joshua D. Drake <jd@commandprompt.com>
@ 2006-03-31 16:19 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-03-31 16:31 ` Re: Ubuntu: Start and Stop Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2006-03-31 16:19 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Sidar López Cruz <sidarlopez@hotmail.com>; pgsql-admin
"Joshua D. Drake" <jd@commandprompt.com> writes:
> sudo su -
> /etc/init.d/postgresql (or /etc/init.d/postgresql8) stop/start
Or easier, just
sudo /sbin/service postgresql stop/start
You will need to add your own userid to the sudoers list if it's
not already there.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Ubuntu: Start and Stop
2006-03-31 15:32 Ubuntu: Start and Stop Sidar López Cruz <sidarlopez@hotmail.com>
2006-03-31 16:07 ` Re: Ubuntu: Start and Stop Joshua D. Drake <jd@commandprompt.com>
2006-03-31 16:19 ` Re: Ubuntu: Start and Stop Tom Lane <tgl@sss.pgh.pa.us>
@ 2006-03-31 16:31 ` Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 5+ messages in thread
From: Joshua D. Drake @ 2006-03-31 16:31 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Sidar López Cruz <sidarlopez@hotmail.com>; pgsql-admin
>
> sudo /sbin/service postgresql stop/start
>
> You will need to add your own userid to the sudoers list if it's
> not already there.
Just for reference, Ubuntu automatically adds the first user created to
the sudoers file and actually disables the ability to "log in" as root.
Sincerely,
Joshua D. Drake
>
> regards, tom lane
>
--
=== 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/
^ permalink raw reply [nested|flat] 5+ messages in thread
* FW: Ubuntu: Start and Stop
@ 2006-03-31 17:47 Andy Shellam <andy.shellam@mailnetwork.co.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Andy Shellam @ 2006-03-31 17:47 UTC (permalink / raw)
To: pgsql-admin
At risk of going off the original subject:
To re-enable root access in Ubuntu, login as your first created user, and
type "sudo passwd root" - type in a new root password, confirm it and bingo,
your root account is ready for direct login, should you need it.
Andy
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Joshua D. Drake
Sent: Friday, 31 March, 2006 5:32 pm
To: Tom Lane
Cc: Sidar López Cruz; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Ubuntu: Start and Stop
>
> sudo /sbin/service postgresql stop/start
>
> You will need to add your own userid to the sudoers list if it's
> not already there.
Just for reference, Ubuntu automatically adds the first user created to
the sudoers file and actually disables the ability to "log in" as root.
Sincerely,
Joshua D. Drake
>
> regards, tom lane
>
--
=== 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/
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
!DSPAM:14,442d599a35047224215988!
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2006-03-31 17:47 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-31 15:32 Ubuntu: Start and Stop Sidar López Cruz <sidarlopez@hotmail.com>
2006-03-31 16:07 ` Joshua D. Drake <jd@commandprompt.com>
2006-03-31 16:19 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-03-31 16:31 ` Joshua D. Drake <jd@commandprompt.com>
2006-03-31 17:47 FW: Ubuntu: Start and Stop Andy Shellam <andy.shellam@mailnetwork.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox