Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-31 Thread Stephane Bortzmeyer
On Tue, Oct 28, 2008 at 07:13:38AM -0700, Tim Bruce - Postgres <[EMAIL PROTECTED]> wrote a message of 41 lines which said: > Wouldn't it be better to add the line 'sudo su - postgres' as the > entry (command) for the user(s) in the sudoers file? Simpler, set the "runas" parameter: jsmith ALL

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-28 Thread Sam Mason
On Tue, Oct 28, 2008 at 08:57:30AM -0400, Tom Lane wrote: > Sam Mason <[EMAIL PROTECTED]> writes: > > On Tue, Oct 28, 2008 at 10:42:47AM +0100, Thomas wrote: > >> An easy trick I have found to set postgres password: $ sudo passwd > >> postgres, and now you can type a new password. So now you can sw

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-28 Thread Tim Bruce - Postgres
On Tue, October 28, 2008 05:57, Tom Lane wrote: > Sam Mason <[EMAIL PROTECTED]> writes: >> On Tue, Oct 28, 2008 at 10:42:47AM +0100, Thomas wrote: >>> An easy trick I have found to set postgres password: $ sudo passwd >>> postgres, and now you can type a new password. So now you can switch >>> use

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-28 Thread Sam Mason
On Tue, Oct 28, 2008 at 01:43:08PM +0100, Thomas wrote: > Yes this allows to login remotely through ssh for instance. But it > doesn't offer a bigger backdoor than having a weak password on a sudo > account. In my eyes, the you've just increased the attack surface available for getting the data---

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-28 Thread Tom Lane
Sam Mason <[EMAIL PROTECTED]> writes: > On Tue, Oct 28, 2008 at 10:42:47AM +0100, Thomas wrote: >> An easy trick I have found to set postgres password: $ sudo passwd >> postgres, and now you can type a new password. So now you can switch >> user with: $ su postgres, and then connect to the DB with

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-28 Thread Thomas
Yes this allows to login remotely through ssh for instance. But it doesn't offer a bigger backdoor than having a weak password on a sudo account. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-ge

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-28 Thread Sam Mason
On Tue, Oct 28, 2008 at 10:42:47AM +0100, Thomas wrote: > An easy trick I have found to set postgres password: $ sudo passwd > postgres, and now you can type a new password. So now you can switch > user with: $ su postgres, and then connect to the DB with psql. Won't that allow logins to the postg

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-28 Thread Thomas
An easy trick I have found to set postgres password: $ sudo passwd postgres, and now you can type a new password. So now you can switch user with: $ su postgres, and then connect to the DB with psql. Beware of pg_hba.conf, it is a bit tricky to understand how the mechanism of authentification work

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-28 Thread Tony Caduto
Shashank Sahni wrote: when i posted the question on dspace mailing list..one of the guy replied me with this solution.. createuser -h localhost -U postgres -d -A -P dspace but he said that to execute the above command i must know the password for the user postgres.. Edit the pg_hba.conf f

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-27 Thread Scott Marlowe
On Mon, Oct 27, 2008 at 11:34 PM, Shashank Sahni <[EMAIL PROTECTED]> wrote: > > On Tue, Oct 28, 2008 at 10:52 AM, Tony Caduto > <[EMAIL PROTECTED]> wrote: >> >> Edit the pg_hba.conf file and add a entry for the PC you are doing your >> admin from and set it to Trust. >> When set to trust you won't

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-27 Thread Shashank Sahni
On Tue, Oct 28, 2008 at 10:52 AM, Tony Caduto < [EMAIL PROTECTED]> wrote: > > Edit the pg_hba.conf file and add a entry for the PC you are doing your > admin from and set it to Trust. > When set to trust you won't need a password, then use the admin tool of > your choice to change the postgres pas

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-27 Thread Scott Marlowe
On Mon, Oct 27, 2008 at 10:55 PM, Shashank Sahni <[EMAIL PROTECTED]> wrote: > > >> createuser: could not connect to database postgres: FATAL: password >> authentication failed for user "postgres" >> >> Odd I would have expected it to say something about identd >> authentication failing. >> >> H

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-27 Thread Shashank Sahni
createuser: could not connect to database postgres: FATAL: password > authentication failed for user "postgres" > > Odd I would have expected it to say something about identd > authentication failing. > > Have you tried: > > sudo su - postgres > createuser -d -A -P dpsace > > ? > Oh... I am so

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-27 Thread Scott Marlowe
On Mon, Oct 27, 2008 at 10:38 PM, Shashank Sahni <[EMAIL PROTECTED]> wrote: > Hello people, > I was trying to install dspace on my computer and it > required postgresql as a prerequisite. Since I am using Ubuntu so i just > downloaded and installed it using synaptic package ma

[GENERAL] How to know the password for the user 'postgres'

2008-10-27 Thread Shashank Sahni
Hello people, I was trying to install dspace on my computer and it required postgresql as a prerequisite. Since I am using Ubuntu so i just downloaded and installed it using synaptic package manager. For the installation of dspace i was supposed to exeucte the following comman