Re: Createdb Problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Louise Cofield" <lcofield(at)box-works(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Createdb Problems
Date: 2003-11-07 22:04:30
Message-ID: 2021.1068242670@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Louise Cofield" <lcofield(at)box-works(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-11-07 22:05:49 Re: Createdb Problems
Previous Message Louise Cofield 2003-11-07 21:59:03 Re: Createdb Problems