Hey ho, A couple of days ago, I wanted to start using PostgreSQL instead of MySQL. Figuring Debian packages mostly function properly out of the box, a source installation seemed not worth the trouble, so I apt-get installed postgresql-8.0.
Everything seemed fine at first, but when I tried to take the approach with the five steps for the impatient, as described in README.Debian.gz in /usr/share/doc/postgresql-common/, things just won't work out... The second step would be to open a shell for the postgres user, after that, I should "createuser -A -D <my Unix login>", but here's how that goes: [16:44:30 tom ~] su -c "su postgres" Password: [16:44:41 tom ~] createuser -A -D tom createuser: could not connect to database template1: FATAL: user "tom" does not exist [16:44:53 tom ~] Firstly, the su-to-postgres doesn't seem to work. In my auth.log, I can see logins for postgres that don't even last a second... Second, the error message seems to suggest it's trying to connect to the (default?) database of template1, which I don't think is what I want, either... I hope I'm not overlooking something very obvious, or otherwise asking the wrong questions, but could anyone tell me what I'm doing wrong? Cheers, Tom -- keys: http://tmp.verbreyt.be/files/ (abwaerts.asc & verbreyt.asc) --- np: Polygon Window - If it Really is Me -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
