Re: Replication

Поиск
Список
Период
Сортировка
От Holger Marzen
Тема Re: Replication
Дата
Msg-id Pine.LNX.4.44.0203011010120.24861-100000@bluebell.marzen.de
обсуждение исходный текст
Ответ на Replication  (George Osvald <mail@okstudio.com.au>(by way of George Osvald <mail@okstudio.com.au>))
Список pgsql-general
On Fri, 1 Mar 2002, George Osvald wrote:

> I am running Postgresql at my office and I am considering running it on the
> net as well. My ISP only has MYSQL so I would have to set up my own
> postgresql server on my user account. I have a few questions:

If you use PHP there then it is probably neccessery to recompile PHP
with --enable-pgsql.

> -Can I use replication over ADSL connection?

If it's a Unix/Linux box you can dump your local db and ssh to the
remote machine, running psql with i/o-redirection from the local
machine. ssh crypts and can compress on the fly.

You then don't need to open the postgres tcp-port to the world because
you run psql on the remote machine.


--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1


В списке pgsql-general по дате отправления:

Предыдущее
От: George Osvald (by way of George Osvald
Дата:
Сообщение: Replication
Следующее
От: "Marc Polatschek"
Дата:
Сообщение: Re: SQL statement : list table details