Re: Restarting, ownership, and permissions

From: Adrian Phillips <adrianp(at)powertech(dot)no>
To: ama-list(at)mltp(dot)com
Cc: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restarting, ownership, and permissions
Date: 2003-09-03 15:05:19
Message-ID: 87iso9q5e8.fsf@grannyogg.localnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "Richard" == Richard Huxton <dev(at)archonet(dot)com> writes:

Richard> Hmm - so you can't "su - postgres" because as "admin"
Richard> you'll need a password. Off the top of my head you
Richard> could:

One possibility given ssh access to the machine, from admin :-

ssh postgres(at)localhost <command>

making sure that admin can ssh to postgres without a password or
passphrase,

Sincerely,

Adrian Phillips

--
Who really wrote the works of William Shakespeare ?
http://www.pbs.org/wgbh/pages/frontline/shakespeare/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2003-09-03 15:11:10 Re: Trunc in Postgres
Previous Message Alvaro Herrera Munoz 2003-09-03 15:03:41 Re: Using oids