X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AE894D1DD3B for ; Mon, 16 Feb 2004 20:20:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 79153-04 for ; Mon, 16 Feb 2004 16:20:08 -0400 (AST) Received: from mail.kzsdabas.sulinet.hu (comp3.kzsdabas.sulinet.hu [195.199.4.3]) by svr1.postgresql.org (Postfix) with ESMTP id 09BDFD1D3DC for ; Mon, 16 Feb 2004 16:20:06 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by mail.kzsdabas.sulinet.hu (Postfix) with ESMTP id 565F41C08B0A; Mon, 16 Feb 2004 20:47:24 +0100 (CET) Received: from mail.kzsdabas.sulinet.hu ([127.0.0.1]) by localhost (linux.kzsdabas.hu [127.0.0.1]) (amavisd-new) with ESMTP id 31270-10; Mon, 16 Feb 2004 20:47:24 -0000 (CET) Received: from kzsdabas.sulinet.hu (unknown [192.168.0.254]) by mail.kzsdabas.sulinet.hu (Postfix) with ESMTP id DBAE41C08B09; Mon, 16 Feb 2004 20:47:23 +0100 (CET) Message-ID: <40311E87.4090701@kzsdabas.sulinet.hu> Date: Mon, 16 Feb 2004 20:48:23 +0100 From: =?ISO-8859-1?Q?G=E9mes_G=E9za?= User-Agent: Mozilla/5.0 (X11; U; Linux i686; hu-HU; rv:1.4) Gecko/20030630 X-Accept-Language: hu, en-US MIME-Version: 1.0 To: Pedro Almeida Cc: pgsql-admin@postgresql.org Subject: Re: pgsql initial superuser References: <40310F4B.7010800@netvisao.pt> In-Reply-To: <40310F4B.7010800@netvisao.pt> X-Enigmail-Version: 0.76.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new amavisd-new-20020630 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/242 X-Sequence-Number: 12416 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Pedro Almeida írta: | kaolin fire wrote: | |> try user 'pgsql' :) that's the default initially created superuser, no |> password (it would be good to give it one). |> |> -kaolin fire |> -http://erif.org/code/fallingup/ for a 'spin' on tetris |> |> | That was a quick response :-) | | using a clean pg_hba.conf file (no user lines added), this is what | happened: | | ******* | ~# createuser -Upgsql | Enter name of user to add: blabla | Shall the new user be allowed to create databases? (y/n) n | Shall the new user be allowed to create more new users? (y/n) n | psql: FATAL: IDENT authentication failed for user "pgsql" | | createuser: creation of user "blabla" failed | ******* | | What am I doing wrong ? | | ---------------------------(end of broadcast)--------------------------- | TIP 9: the planner will ignore your desire to choose an index scan if your | joining column's datatypes do not match Add a line: local all all ident sameuser to your pg_hba.conf restart postgresql find out under what userid is your postgresql running typicaly it would be postgres, I'll supose that it is postgres: su postgres and do whatever you like with your database cluster. Because of this I would suggest as a first step to do: psql template1 SQL commands follow: ALTER USER postgres password='SomeReallyBigSecretHere' ; Hope it helps. Cheers, Geza -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAMR6G/PxuIn+i1pIRAoaAAKCBALjM0r1nQ3K8anMwrDh/BGscOgCggs18 V+YlMMBEGys7jd7LzfV5M0Y= =udMf -----END PGP SIGNATURE-----