Re: [ADMIN] Possibilities of PgSQL

2007-08-24 Thread Karel Břinda
100MB of text in each row?? is each row a copy of the english dictionary? No, that was only example. It will be web application (Python + PgSQL). I thought about table with records + table with changes but is it some easy way how to get differences between 2 strings? Shane Ambler píše v

Re: [ADMIN] tar, but not gnu tar

2007-08-24 Thread Peter Eisentraut
Am Freitag, 24. August 2007 03:58 schrieb Tom Lane: Tena Sakai [EMAIL PROTECTED] writes: This seems to contradict what we say about GNU tar? Is this GNU tar? What version? Yes, it is GNU tar v1.14 FWIW, I tried this on Fedora Core 6 while running pgbench: [EMAIL PROTECTED] ~]$ tar

Re: [ADMIN] Possibilities of PgSQL

2007-08-24 Thread Shane Ambler
Karel Břinda wrote: 100MB of text in each row?? is each row a copy of the english dictionary? No, that was only example. It will be web application (Python + PgSQL). I thought about table with records + table with changes but is it some easy way how to get differences between 2 strings?

[ADMIN] run postgres.exe as a Windows Administrative account

2007-08-24 Thread Yingqi Tang
All, I am new to postgreSQL and the first time I tried to execute postgres.exe I got an error saying the services must be started as a non-administrative windows user. But I checked the doc and it says after 8.2 it is possible to run postgres.exe as a windows administrator. So a little bit

[ADMIN] PostgreSQL and virtualization

2007-08-24 Thread Arnau
Hi all, I'd like to do some tests with replication, high availability, ... with PostgreSQL. The problem I have is I don't have enough hardware to do such tests, so I'd like to use virtualization. I'd like to do it using linux. Nowadays there several products to do it Xen, Qemu, VMware, ...

Re: [ADMIN] PostgreSQL and virtualization

2007-08-24 Thread Adam Tauno Williams
I'd like to do some tests with replication, high availability, ... with PostgreSQL. The problem I have is I don't have enough hardware to do such tests, so I'd like to use virtualization. I'd like to do it using linux. Nowadays there several products to do it Xen, Qemu, VMware, ... and

Re: [ADMIN] PostgreSQL and virtualization

2007-08-24 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Arnau wrote: Hi all, I'd like to do some tests with replication, high availability, ... with PostgreSQL. The problem I have is I don't have enough hardware to do such tests, so I'd like to use virtualization. I'd like to do it using linux.

Re: [ADMIN] Logging the starting and stopping of PostgreSQL

2007-08-24 Thread Campbell, Lance
Ganesan, Thanks so much. I never read about that directory. Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu From: Chander Ganesan

Re: [ADMIN] Installing Postgres

2007-08-24 Thread Medi Montaseri
Just dont get into the habbit of moving db files around like too muchfilesystems will spead your files all over the place and your database will slow down Medi On 8/23/07, Campbell, Lance [EMAIL PROTECTED] wrote: Tom, It is nice to know that you can actually move the database by

Re: [ADMIN] Warm-Backup configuration question

2007-08-24 Thread Kenji Morishige
Hmm. I recently installed 8.2.4 out of ports (FreeBSD) and didn't see that file in contrib. I'd like to take a look at it. Kenji On Fri, Aug 24, 2007 at 07:18:12AM +0300, Mikko Partio wrote: On 8/24/07, Kenji Morishige [EMAIL PROTECTED] wrote: I've got 2 identical servers configured