On 18/08/2011 17:55, Tom Browder wrote:
> On Thu, Aug 18, 2011 at 08:48, Jehan-Guillaume (ioguix) de Rorthais
> wrote:
>> On 18/08/2011 15:37, Tom Browder wrote:
>>> On Thu, Aug 18, 2011 at 07:37, Jehan-Guillaume (ioguix) de Rorthais
>>> wrote:
>>>&
On 18/08/2011 15:37, Tom Browder wrote:
> On Thu, Aug 18, 2011 at 07:37, Jehan-Guillaume (ioguix) de Rorthais
> wrote:
>> On 18/08/2011 13:54, Tom Browder wrote:
>>> On Thu, Aug 18, 2011 at 05:40, (ioguix) de Rorthais wrote:
>>>> On 18/08/2011 01:20, Tom Brow
x/32 md5
sounds good.
That means that you did set a password to user postgres ? did you try to
login with the following commands using your own system user (not postgres):
psql postgres postgres
psql -h 127.0.0.1 postgres myuser
first one use unix socket, second one inet.
>>> I have asked this of the phppgadmin group but I think it may be my
>>> postgresql setup.
>
>> Looks like I missed it...where ?
>
> Oops, I never sent the message, sorry, my mistake.
>
> Thanks, Jehan-Guillaume.
>
> -Tom
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hello,
On 18/08/2011 01:20, Tom Browder wrote:
> [...]
>
> I have these lines in my pg_hba.conf file:
>
> host all myuser /32 md5
> host all postgres /32 md5
>
> However, I cannot successfully login with phppgadmin on the remote host.
>
>
>
> -Original Message-
> From: pgsql-admin-ow...@postgresql.org
> [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Jehan-Guillaume
> (ioguix) de Rorthais
> Sent: Tuesday, October 26, 2010 4:22 PM
> To: Martin Povolny
> Cc: pgsql-admin@postgresql.org
> Subject:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Or even compress AND split it !
pg_dump -Fc dbname | split -b 1G - dump_dbname
and restore:
cat dump_dbname* | pg_restore -d dbname
or
cat dump_dbname* | pg_restore | psql dbname
Le 26/10/2010 23:51, Samuel Stearns a écrit :
> You can also try
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
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
if my problem is related to that ?
Thanks again.
Martin Fandel wrote:
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
l.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
tarball as is (just put them back to /var/lib/pgsql), the da
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
hello,
I crashed my server, and I didn't took the precaution to pg_dump one of
my database :-(
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 suf
12 matches
Mail list logo
