On Sun, May 20, 2007 at 04:44:57PM -0400, Roberto C. Sánchez wrote: > On Sun, May 20, 2007 at 06:49:07PM +0200, csanyipal wrote: > > > > My /etc/postgresql/7.4/main/pg_hba.conf on my Debian Etch has the > > following lines enabled: > > > > -----------------------------------------> > > local all postgres ident sameuser > > local all all ident sameuser > > host all all 127.0.0.1 255.255.255.255 md5 > > host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff md5 > > -----------------------------------------< > > > > I can to do the following on xterm window: > > > > $ sudo su - postgres > > [EMAIL PROTECTED]:~$ > > > > There I can to connect to the template1 database out there, or can > > create new users. > > > > But when I try to install tutos2 then get the abowe wroted errors. Why? > > Biang installing tutos2 I have to add password for postgres user; there > > I add the root password of my Debian system out there. Is it right? > > > The postgres user should not have a password! > > Please post what shows up in the postgres logs when you try and install > tutos2. To do this, open up a terminal window and run `sudo tail -f > /var/log/postgresql/postgres.log` and then run the installation of > tutos2. Post what shows up in the postgres log here.
------------------------------> $ sudo tail -f /var/log/postgresql/postgresql-7.4-main.log 2007-05-20 17:40:59 LOG: az adatbáziskezelő rendszer a(z) 2007-05-20 17:40:57 CEST időpontban leállítva 2007-05-20 17:40:59 LOG: ellenőrzőpont-bejegyzés a(z) (0, 9CD7F8) pozíciónál 2007-05-20 17:40:59 LOG: redo-bejegyzés a(z) (0, 9CD7F8) pozíciónál; undo-bejegyzés a(z) (0, 0) pozíciónál; leállítás TRUE 2007-05-20 17:40:59 LOG: next transaction ID: 578; next OID: 17144 2007-05-20 17:40:59 LOG: az adatbáziskezelő munkára kész 2007-05-20 17:40:59 LOG: az induló csomag nem teljes 2007-05-20 17:51:16 FATAL: database "postgres" does not exist 2007-05-20 18:02:54 ERROR: zero-length delimited identifier at or near """" at character 30 2007-05-20 18:39:16 ERROR: current user cannot be dropped 2007-05-20 18:39:26 FATAL: a(z) "root" felhasználó nem létezik ------------------------------< This abowe is in Hungarian. I can't remember how can I set the LANG environment variable for a command to show up messages in English? -- Regards, Paul Csányi http://www.freewebs.com/csanyi-pal/index.htm -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]