[ADMIN] Advice about -B n_buffers option

2000-04-06 Thread Robert Williams
I have a postmaster process that is crashing periodically. I haven't turned on debugging yet, but I suspect the number of buffers may be low (its 64). Does anyone have some general observations about the importance of having more buffers? -B n_buffers n_buffers is the number of

[ADMIN] pg_dump ineffective on 6.4.2?

1999-06-11 Thread Robert Williams
I have two servers (Redhat) with identical databases. I upgraded to one of them to 6.4.2 (RH6.0) and restored the database on that machine from a pg_dump created on the other (6.3: RH5.2) machine. Now pg_dump does not function properly on the 6.4.2 machine. I've included listings of the original

Re: [ADMIN] Encrypted connections to Postgres

1999-06-11 Thread Robert Williams
Brian Baquiran wrote: > I'm talking with the boss about Postgres and the conversation turned to > security. What kind of security features does Postgres have? I'm aware of the > host-based authentication in pg_hba.conf. Are the actual connections to the > database (SQL queries and what they retur