This is someones' elses' posting that i have preserved
shud be useful.
regds
mallah.
~`
Well,
the most correct way to do a logrotate is ( Redhat ):
1) Put on your postgresql.conf the following lines:
syslog = 2
syslog_facility = 'L
Hi Everybody,
I am new to postgresql. I started my postgres using the command
postmaster -D /usr/local/pgsql/data > logfile 2>&1 &
Now after running it for some time I noticed that the size of this logfile has become very large. Is this logfile used to store any important information used by the da
I am a new comer in this millis. Can you help me how to configure the
postgreSQL server which has some databases. I mean 5 databses is spread to
different hardisk. For example a_db to hda1, b_db to hdb1, etc...
TIA
Best regards
Aris Wendy
---(end of broadcast)-
ext3/xfs by default journal the meta-data changes. You can turn this
off in ext3 by simply mounting as ext2.
On Wed, 29 Jan 2003 13:38:55 -0500
[EMAIL PROTECTED] wrote:
> XFS seems to work pretty well. ext3 uses journaling which is very
> slow, xfs uses it as well but xfs tends to be faster ove
XFS seems to work pretty well. ext3 uses journaling which is very slow, xfs uses it
as well but xfs tends to be faster overall. Try adding data =writeback to the mount
parameters when using ext3 or xfs. I think this turns of journaling.
---(end of broadcast)---
I'm in the process of adding a new filesystem to our development server
for Postgres data. I have been using ext3fs and ext2fs for PG databases
and I haven't been impressed with the performance.
So, has anyone out there benchmarked the various Linux filesystems for
PG performance? More informati
On Wed, 2003-01-29 at 09:20, Yudha Setiawan wrote:
> Dear Master;
> So There's no way to put the Begin Work, Commit Work or Rollback
> inside Trigger's Function...
> Some Explanation will be better :b
No.
All triggers happen within a transaction, whether explicit or implicit
and transactions
Dear Master;
So There's no way to put the Begin Work,
Commit Work or Rollback inside Trigger's Function...
Some Explanation will be better
:b
GOD Bless You All.
Yudha Setiawan.VoIP
No. :
01119311223344
On Tue, Jan 28, 2003 at 15:39:03 -0800,
Jerry Asher <[EMAIL PROTECTED]> wrote:
>
> Does the order of statements in pg_hba.conf matter?
> Is there a priority and a fallback of sorts? Try this first mechanism
> and if that fails, try the next mechanism?
Yes the order matters. Only the first rule
