PGDATA=/var/lib/pgsql
Should read
PGDATA=/var/lib/pgsql/data
so the database would be /var/lib/pgsql/data/base, not /var/lib/pgsql/base
On Mon, 10 Aug 1998, atif ahmed wrote:
> hi all
> i installed postgresql 6.3.2-6 that comes with redhat 5.1 as a root. "i
> tried to install it as a regul
hi all
i installed postgresql 6.3.2-6 that comes with redhat 5.1 as a root. "i
tried to install it as a regular user but rpm wouldn't allow me"
anyway, after i installed it i logged into my regular account added the
following to my bash_profile:
PATH=$PATH:/usr/bin/postgresql
PGDATA=/var/lib/pgs
you need to add the other users as postgres users..
createuser (username)
On Mon, 10 Aug 1998, Drew Hamilton wrote:
> Hi there!
>
> I've just installed Postgres and now I'm having problem with authentication.
> Everything works properly when I log on "directly" (logged on to UNIX as
> the sa
Hi there!
I've just installed Postgres and now I'm having problem with authentication.
Everything works properly when I log on "directly" (logged on to UNIX as
the same user as I'm logging onto Postgres):
[postgres@urd pgsql]$ psql ichallenge
Welcome to the POSTGRESQL interactive sql monitor:
