X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 60F2752A15 for ; Fri, 1 Jul 2005 06:07:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 42700-05 for ; Fri, 1 Jul 2005 09:06:58 +0000 (GMT) Received: from smtp2.int-evry.fr (smtp2.int-evry.fr [157.159.10.45]) by svr1.postgresql.org (Postfix) with ESMTP id 869C5529E2 for ; Fri, 1 Jul 2005 06:06:54 -0300 (ADT) Received: from [157.159.50.197] (calaz.int-evry.fr [157.159.50.197]) by smtp2.int-evry.fr (Postfix) with ESMTP id E6D048023; Fri, 1 Jul 2005 11:06:49 +0200 (CEST) Message-ID: <42C507BA.7070304@free.fr> Date: Fri, 01 Jul 2005 11:07:06 +0200 From: jehan procaccia User-Agent: Mozilla Thunderbird 1.0.2-6 (X11/20050513) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Ben Kim Cc: Martin Fandel , pgsql-admin@postgresql.org, Lydie.Soler@inapg.inra.fr, Yves Marteau Subject: Re: restore database from bare files References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-INT-MailScanner-Information: Please contact the ISP for more information X-INT-MailScanner: Found to be clean X-INT-MailScanner-SpamCheck: X-MailScanner-From: jehan.procaccia@free.fr X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/2 X-Sequence-Number: 18058 Ben Kim wrote: >>ezpublish_db-# ALTER USER ezpublish SET PASSWORD secret; >>ERROR: syntax error at or near "$" at character 1 >> >> > >I wonder why you have "ezpublish_db-#" instead of "ezpublish_db=#"? I just >noticed it, and to me it happens usually when something's been carried >over from the previous line. My 2 pence... > > indeed I typed a comment before without ending it with ";" that might explain the "syntax error" ! for my pb, I have part of an explanation -> I forgot to recreate the user ! so here I go again in one command to create user and set password: $ createuser ezpublish -P Enter password for new user: ******* Enter it again: ******* Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) n CREATE USER then: $ psql ezpublish_db -U ezpublish -W Password: ******* psql: FATAL: IDENT authentication failed for user "ezpublish" I really don't understand :-( If I go with postgres user, no pb: $ psql ezpublish_db -U postgres Welcome to psql 7.4.8, the PostgreSQL interactive terminal. if it can help to debug, here's my users list: ezpublish_db=# select * from pg_user; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig -----------+----------+-------------+----------+-----------+----------+----------+----------- postgres | 1 | t | t | t | ******** | | ezpublish | 100 | t | f | f | ******** | | (2 rows) If you have an idea , I'll really apreciate Thanks !. > >Regards, > >Ben Kim >Developer >College of Education >Texas A&M University > > >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings > >