How do you have your pg_hba.conf file setup ?
If on the shell as the postgres user, you can login into the
"db_stats" database without a password being asked for than you should
not need one.
Try out:
postgres$> psql db_stats
and see if you can login without asking for a PW.. check your
My question are just how I can connect from the C api with an md5
password or it's not possible ?
Regards
Guy
Marcelo Martins a écrit :
How do you have your pg_hba.conf file setup ?
If on the shell as the postgres user, you can login into the
"db_stats" database without a
esult. I am not convinced,
however.
Instead of your dd suggestion, I thought of copying
0084 and calling it 0085. I have no idea what consiquence
there might be. Perhaps, you can comment?
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-----
From: Marcelo Martins [mailto:[EMAIL
Hi Rafael,
The result there means that the minimal should be 4.69Mb for
shared_buffers
As a rule of thumb the shared buffers should be between 10% - 15% of
available RAM that assuming such is a dedicated PG server.
I have worked on some servers where I set shared buffers lower than
10%, it
pg_dumpall has a flag for globals only which dumps an SQL file with
that info. Check it out pg_dumpall --help
On Dec 4, 2008, at 10:55, Chris Curvey <[EMAIL PROTECTED]> wrote:
I'm a newbie to PG administration (although I have experience with
other DBs). I need to move a single database to
Do you guys have any suggestions on monitoring tools for postgresql
that would provide graphing of data & alerts ?
I have looked and tried out hyperic, munin, Nimbus but was hoping to
something better.
Thanks,
Marcelo
PostgreSQL DBA
Linux/Solaris System Administrator
--
Sent via pgsql-ad
Cool, I have actually been trying out Zabbiz 1.6.x now since I like it
better than munin.
Thanks,
Marcelo
PostgreSQL DBA
Linux/Solaris System Administrator
On Jan 19, 2009, at 9:56 AM, Jaume Sabater wrote:
On Mon, Jan 19, 2009 at 4:38 PM, Marcelo Martins > wrote:
Do you guys have
