thanks that was in the doc ! indeed I needed to put "local ezpublish_db
ezpublish trust" before other rules , as the first rule that match end
the reading of pg_hba.conf .
Thanks again .
Ben Kim wrote:
psql: FATAL: IDENT authentication failed for user "ezpublish"
This might help, o
>psql: FATAL: IDENT authentication failed for user "ezpublish"
This might help, or you may want to check or post your pg_hba.conf.
http://archives.postgresql.org/pgsql-sql/2004-03/msg00202.php
(or
http://www.postgresql.org/docs/7.4/interactive/auth-methods.html#AUTH-IDENT)
HTH,
Ben Kim / Dev
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 previ
>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.
very good, that worked fine :-)
I restored the files from tar, started a postgresql 7.3 on an old redhat
9 ! pg_dump my database, psql it back to my postgresql 7.4 on my
production RHEL4 server .
still a small pb, I seem to have lost authentification. (although
pg_hba.conf was restore also)
Hi,
try this:
psql -t -d yourdb -c "SELECT datid FROM pg_stat_database WHERE
datname='yourdb';"
http://www.postgresql.org/docs/8.0/static/monitoring-stats.html
Greetings,
Martin
Am Donnerstag, den 30.06.2005, 12:57 +0200 schrieb jehan-free:
> OK, I'am not yet at restarting postgres .. but if a
OK, I'am not yet at restarting postgres .. but if at get pb then I check
that , thanks !
For now , How can I tell from the bare file the mapping between a
database name and the number appearing in /var/lib/pgsql/base directory
I have :
pgsql/data/base/1/
pgsql/data/base/16975/
pgsql/data/base/16
Hi
Maybe you must reset the WAL's
( http://www.postgresql.org/docs/7.3/interactive/app-pgresetxlog.html )
after restoring from tarball if postgres doesn't start.
Am Donnerstag, den 30.06.2005, 07:34 +0200 schrieb jehan:
> So I must one way or another run a 7.3, restore the file from the
> tarbal
e junio de 2005 15:48
Para: jehan procaccia
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] restore database from bare files
jehan procaccia wrote:
However I do have a tar file of the filesystem , it was on a RHEL 3
with rh-postgresql-server-7.3.9-2 and I have a tar of /var/lib/pgslq
will
7.3.9 doesn't
need to dump and restore of databases)
greeting.
-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] nombre de Peter Eisentraut
Enviado el: miércoles, 29 de junio de 2005 15:48
Para: jehan procaccia
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] restor
jehan procaccia wrote:
> However I do have a tar file of the filesystem , it was on a RHEL 3
> with rh-postgresql-server-7.3.9-2 and I have a tar of /var/lib/pgslq
> will just restoring the whole directory /var/lib/pgsql will suffices
Assuming that you made the tarball when the server was shut dow
11 matches
Mail list logo
