| From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL Qs |
| Date: | 2003-05-07 20:02:49 |
| Message-ID: | 20030507220249.B11722@hermes.hilbert.loc |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2003-05-07 20:03:49 | Re: PostgreSQL Qs |
| Previous Message | Karsten Hilbert | 2003-05-07 19:58:41 | Re: select offset by alphabetical reference |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2003-05-07 20:03:49 | Re: PostgreSQL Qs |
| Previous Message | Bernd von den Brincken | 2003-05-07 19:57:56 | Re: [SQL] An unresolved performance problem. |