Re: Restarting, ownership, and permissions - Mailing list pgsql-general

From Adrian Phillips
Subject Re: Restarting, ownership, and permissions
Date
Msg-id 87iso9q5e8.fsf@grannyogg.localnet
Whole thread Raw
In response to Re: Restarting, ownership, and permissions  (Richard Huxton <dev@archonet.com>)
List pgsql-general
>>>>> "Richard" == Richard Huxton <dev@archonet.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@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/

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: What is the good equivalent for ENUM ?
Next
From: "Amin Schoeib"
Date:
Subject: Re: Localization (for dates) Oracle vs. Postgresql