Re: Createdb Problems - Mailing list pgsql-novice

From Tom Lane
Subject Re: Createdb Problems
Date
Msg-id 2021.1068242670@sss.pgh.pa.us
Whole thread Raw
In response to Re: Createdb Problems  ("Louise Cofield" <lcofield@box-works.com>)
List pgsql-novice
"Louise Cofield" <lcofield@box-works.com> writes:
> We changed the ownership of all the postgres files and directories to
> postgres.  Any further ideas?

That's not going to help, because whatever user name was entered in
pg_shadow is still going to be in pg_shadow.  If you are regretting
your initial choice of who to run initdb as, your best bet is to shut
down the postmaster, rm -rf the PGDATA directory, re-run initdb as the
right person, and restart the postmaster.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Louise Cofield"
Date:
Subject: Re: Createdb Problems
Next
From: Tom Lane
Date:
Subject: Re: Createdb Problems