Re: [GENERAL] Why can't I change a password

2011-01-16 Thread Adrian Klaver
On Sunday 16 January 2011 1:49:43 pm Steve Litt wrote: > On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote: > > If you have configured PG to listen on a TCP/IP port (5432 by default), > > you can also do: > > > >psql -U postgres -h localhost super > > > > Ray. > > Thanks Ray, > > You w

Re: [GENERAL] Why can't I change a password

2011-01-16 Thread Adrian Klaver
On Sunday 16 January 2011 1:49:43 pm Steve Litt wrote: > On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote: > > If you have configured PG to listen on a TCP/IP port (5432 by default), > > you can also do: > > > >psql -U postgres -h localhost super > > > > Ray. > > Thanks Ray, > > You w

Re: [GENERAL] Why can't I change a password

2011-01-16 Thread Steve Litt
On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote: > If you have configured PG to listen on a TCP/IP port (5432 by default), > you can also do: > >psql -U postgres -h localhost super > > Ray. Thanks Ray, You were so close! The command that works is this: psql -U super -h loca

Re: [GENERAL] Why can't I change a password

2011-01-16 Thread Raymond O'Donnell
On 16/01/2011 21:39, Steve Litt wrote: On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote: If you have configured PG to listen on a TCP/IP port (5432 by default), you can also do: psql -U postgres -h localhost super Ray. Thanks Ray, My psql seems a lot different from others. Lo

Re: [GENERAL] Why can't I change a password

2011-01-16 Thread Steve Litt
On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote: > If you have configured PG to listen on a TCP/IP port (5432 by default), > you can also do: > >psql -U postgres -h localhost super > > Ray. Thanks Ray, My psql seems a lot different from others. Loook what happened: slitt@mydes

Re: [GENERAL] Why can't I change a password

2011-01-16 Thread Raymond O'Donnell
On 16/01/2011 20:56, Steve Litt wrote: Thanks Dmitriy, It turns out the solution I used was to su to postgres in Linux, and then run the command psql without arguments, at which time I could have my way with any object. More in my responses to you... On Sunday 16 January 2011 06:21:28 Dmitriy

Re: [GENERAL] Why can't I change a password

2011-01-16 Thread Steve Litt
Thanks Dmitriy, It turns out the solution I used was to su to postgres in Linux, and then run the command psql without arguments, at which time I could have my way with any object. More in my responses to you... On Sunday 16 January 2011 06:21:28 Dmitriy Igrishin wrote: > Hey Steve, > > 2011/

Re: [GENERAL] Why can't I change a password

2011-01-16 Thread Dmitriy Igrishin
Hey Steve, 2011/1/16 Steve Litt > Hi all, > > I've somehow messed up something. > > psql super > psql's synopsis is psql [option...] [dbname [username]] Thus, the call "psql super" connects psql to a database "super" but since username unspecified it is connected with current Unix user (w

[GENERAL] Why can't I change a password

2011-01-16 Thread Steve Litt
Hi all, I've somehow messed up something. psql super psql (8.4.5) Type "help" for help. super=> \du+ List of roles Role name | Attributes | Member of | Description ---+-+---+- bobo | | {}| junk |