On Fri, Jul 13, 2001 at 08:43:05AM -0400, Brian Schramm wrote: > I tryed that. I can get in by the postgres user but cannot > create a user from there. It does not give me an error message > but does not create the user eather.
if you can get into the database as user postgres from the command line, you should be able to do what you need, as far as the database is concerned: postgres$ psql mydb mydb=# \h create user you may need to check the host-based access methods in /etc/postgresql/pg_hba.conf as well... # force everyone from everywhere to supply a password host all 0.0.0.0 0.0.0.0 crypt -- DEBIAN NEWBIE TIP #23 from Will Trillich <[EMAIL PROTECTED]> : Wondering what you should BACK UP -- and what you shouldn't? Here's a "how I do it" written by a debian-user regular, Karsten Self: http://kmself.home.netcom.com/Linux/FAQs/backups.html This is a frequent topic on debian-user; check the archives at lists.debian.org for other backup approaches -- search for "backup scheme". Also see http://newbieDoc.sourceForge.net/ ...