Re: PostgreSQL Qs - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: PostgreSQL Qs
Date
Msg-id 20030507220249.B11722@hermes.hilbert.loc
Whole thread Raw
In response to PostgreSQL Qs  (Jon Earle <je_pgsql@kronos.honk.org>)
List pgsql-general
> export DBI_DSN=dbi:Pg:dbname=template1
> export DBI_USER=postgres
> export DBI_PASS=xxxxxx
Routinely accessing your databases as postgres is akin to
running your Debian system as root all the time. Create a
DB user, give proper rights to that user and go from there.

Also, avoid changing template1 unless you know what you are
doing. Create and use another DB for testing.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


pgsql-general by date:

Previous
From: "Scott W. Hill"
Date:
Subject: Re: Restoring 7.3.x Data on 7.2.x Database
Next
From: Jon Earle
Date:
Subject: Re: PostgreSQL Qs