pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Ubuntu: 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>
  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 16:07  Joshua D. Drake <jd@commandprompt.com>
  parent: Sidar López Cruz <sidarlopez@hotmail.com>
  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 16:19  Tom Lane <tgl@sss.pgh.pa.us>
  parent: 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 16:31  Joshua D. Drake <jd@commandprompt.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  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