X-Original-To: pgsql-general@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E0E47476599 for ; Wed, 7 May 2003 16:20:39 -0400 (EDT) Received: from mail.gmx.net (mail.gmx.net [213.165.65.60]) by postgresql.org (Postfix) with SMTP id 1D4DB476530 for ; Wed, 7 May 2003 16:20:33 -0400 (EDT) Received: (qmail 11818 invoked by uid 65534); 7 May 2003 20:20:32 -0000 Received: from p5087EEAB.dip0.t-ipconnect.de (EHLO hermes.hilbert.loc) (80.135.238.171) by mail.gmx.net (mp009-rz3) with SMTP; 07 May 2003 22:20:32 +0200 Received: (from ncq@localhost) by hermes.hilbert.loc (8.11.6/8.11.6/SuSE Linux 0.5) id h47K2n613367 for pgsql-general@postgresql.org; Wed, 7 May 2003 22:02:49 +0200 Date: Wed, 7 May 2003 22:02:49 +0200 From: Karsten Hilbert To: pgsql-general@postgresql.org Subject: Re: PostgreSQL Qs Message-ID: <20030507220249.B11722@hermes.hilbert.loc> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.22.1i Re-X-turn-receipt-to: Karsten.Hilbert@gmx.net Di-X-sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi-X-rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri-X-ority: 2 (High) X-Spam-Status: No, hits=-20.6 required=5.0 tests=BAYES_10,IN_REP_TO,RCVD_IN_NJABL,REFERENCES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/222 X-Sequence-Number: 41877 > 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