Re: [ADMIN] Large Number of Files in pg_xlog

2009-11-30 Thread Tom Lane
Bob Lunney writes: > Is it possible to reduce the number of files in pg_xlog. Currently, > checkpoint_segments is set to 512, which if I understand correctly, > means there could be up to 1025 files in pg_xlog, 16Gb of WAL. Right > now there are 833 files. I've tried setting checkpoint_segments

[ADMIN] Large Number of Files in pg_xlog

2009-11-30 Thread Bob Lunney
Is it possible to reduce the number of files in pg_xlog. Currently, checkpoint_segments is set to 512, which if I understand correctly, means there could be up to 1025 files in pg_xlog, 16Gb of WAL. Right now there are 833 files. I've tried setting checkpoint_segments to a lower number and re

Re: [ADMIN] setting up a client only service

2009-11-30 Thread Tom Lane
Tena Sakai writes: > Is this correct? If so, where can I go to get psql only for > A 32-bit linux machine? Practically all packagings of Postgres separate the server programs from the client-side programs. In the case of the RPMs, for example, you'd just install the base "postgresql" package an

[ADMIN] setting up a client only service

2009-11-30 Thread Tena Sakai
Hi everybody, I have postgres (v8.3.7) running happily on a Linux machine, named X. I want to access the database on X from another linux machine, called Y, on the same network. X is a 64-bit Machine and runs redhat, while Y is a 32-bit machine with centOS. My idea is to have only psql on machi