Re: [ADMIN] replication

2005-02-14 Thread Joshua D. Drake
Fred Blaise wrote: Hello I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one is a failover. I would like to implement a master-slave replication process. I believe replication has been included in the base package since 7.3.x. Hello, There are two major replication options for P

Re: [ADMIN] replication

2005-02-14 Thread Michael Klatt
Christopher Browne wrote: The world rejoiced as [EMAIL PROTECTED] (Fred Blaise) wrote: Hello I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one is a failover. I would like to implement a master-slave replication process. I believe replication has been included in the base packa

Re: [ADMIN] Problem binding postmaster to several interfaces

2005-02-14 Thread Tom Lane
"Milen A. Radev" <[EMAIL PROTECTED]> writes: > The current value of my "listen_addresses" setting is: > listen_addresses = '192.168.0.1, 127.0.0.1' Nothing wrong with that. > but using "netstat -tupan" I still see: > tcp0 0 0.0.0.0:54320.0.0.0:* > LISTEN

Re: [ADMIN] Importing and Exporting Tables.

2005-02-14 Thread Bruno Wolff III
On Mon, Feb 14, 2005 at 13:19:11 +0530, Chandra Mouli S <[EMAIL PROTECTED]> wrote: > Hi, > > I have POSTGRESQL v8.0 for Windows installed in my home computer. > > I work simultaneously in my home and in my office. > > I like someone to help me to find a way to: > > EXPORT the tables in my hom

Re: [ADMIN] replication

2005-02-14 Thread Christopher Browne
The world rejoiced as [EMAIL PROTECTED] (Fred Blaise) wrote: > Hello > > I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one > is a failover. I would like to implement a master-slave replication > process. > > I believe replication has been included in the base package since 7.3

[ADMIN] Problem binding postmaster to several interfaces

2005-02-14 Thread Milen A. Radev
Hi everyone! I have postgresql 8.0.1 installed on a Slackware Linux machine. The machine is a multi-purpose device and it has external and internal interfaces. I would like to limit "postmaster" to listen only to the internal interface and the loopback. I tried to use the new "listen_addresses" di

[ADMIN] Importing and Exporting Tables.

2005-02-14 Thread Chandra Mouli S
Hi, I have POSTGRESQL v8.0 for Windows installed in my home computer. I work simultaneously in my home and in my office. I like someone to help me to find a way to: EXPORT the tables in my home pc to some file format from which I can IMPORT back the same tables in my office system. This is my

[ADMIN] replication

2005-02-14 Thread Fred Blaise
Hello I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one is a failover. I would like to implement a master-slave replication process. I believe replication has been included in the base package since 7.3.x. Do you have any good pointers/how-to to direct me to? Thanks for th

Re: [ADMIN] R-Trees.

2005-02-14 Thread Tsirkin Evgeny
I don't think this is a postgres question it is perl one ,so you are in the wrong place .just as a hint look for a perl module that do what you want *i think perl::Text os something).Any way this is a wrong list . Evgeny Michael Wray wrote: (Please CC me, if you reply as I am out of pocket now a