On Tue, Jan 21, 2014 at 9:00 PM, o1bigtenor <o1bigte...@gmail.com> wrote:
>
>
>
> On Tue, Jan 21, 2014 at 7:24 PM, Chris Travers <chris.trav...@gmail.com>wrote:
>
>> If you are trying to log in as superuser and you don't know what password
>> you set, you can reset it. Usually your postgres account will be locally
>> accessible from the postgres system account only. If that is the case:
>>
>> sudo su postgres -c psql
>>
>> Then if that drops you at a psql prompt, you can reset the superuser
>> password as:
>>
>> ALTER USER postgres WITH PASSWORD 'mysecretpassword' valid until
>> 'infinity';
>>
>> Assuming that postgres is the user and you have password authentication
>> working for that user over tcp/ip, that should work. If it doesn't let me
>> know and I can take a quick look at your PostgreSQL setup.
>>
>
> I used the following:
>
> postgres=# ALTER USER postgres WITH PASSWORD 'secret'password' valid until
> 2039
>
>
> and I am still at the recurring local host . . . as before.
>
> Should I be getting the previous group of emails out so that I can set up
> this end again?
>
> Darald
>
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
