Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgreSQL db temporary on Microsoft IIS 4.0

postgreSQL db temporary on Microsoft IIS 4.0

From
juerg.rietmann@pup.ch
Date:
Hi there

For testing, I have a Microsoft Windows NT Server with IIS 4.0 running in
my DMZ. Currently it is not possible to migrate this server to LinuX. Is
there a way to move an existing postgreSQL 7.0.3 db (with views/sequences)
from a Linux Server to this NT Web server. I have coldfusion on NT, all I
need is the postgres DB or a 100% compatible on NT.

Any ideas ??  Thanks in advance ... jr

============================================
PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland

phone: +4141 790 4040
fax: +4141 790 2545
mobile: +4179 211 0315
============================================

Re: postgreSQL db temporary on Microsoft IIS 4.0

From
"Brent R. Matzelle"
Date:
--- juerg.rietmann@pup.ch wrote:
> Hi there
>
> For testing, I have a Microsoft Windows NT Server with IIS 4.0
> running in
> my DMZ. Currently it is not possible to migrate this server to
> LinuX. Is
> there a way to move an existing postgreSQL 7.0.3 db (with
> views/sequences)
> from a Linux Server to this NT Web server. I have coldfusion
> on NT, all I
> need is the postgres DB or a 100% compatible on NT.

Read the FAQ to setup Postgres on NT:
http://postgresql.readysetnet.com/docs/faq-mswin .  The
migration is as simple as a dump/restore.

Brent

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/

Re: postgreSQL db temporary on Microsoft IIS 4.0

From
Gilles DAROLD
Date:
Hi,


juerg.rietmann@pup.ch wrote:

> Hi there
>
> For testing, I have a Microsoft Windows NT Server with IIS 4.0 running in
> my DMZ. Currently it is not possible to migrate this server to LinuX. Is
> there a way to move an existing postgreSQL 7.0.3 db (with views/sequences)
> from a Linux Server to this NT Web server. I have coldfusion on NT, all I
> need is the postgres DB or a 100% compatible on NT.
>

Why not putting your Linux server on the DMZ ? This certainly be more secure
and a gain of performance. Just acces the remote database from your WinNt
box.
Putting Web apps and the database on the same server is not a good solution
if
you have a heavy load.

Regards,

Gilles DAROLD