[GENERAL] Newbie - Pointers on moving.

2005-02-28 Thread Envbop
Hi

I have to move a pgsql database which is running on a linux box to a Windows 
2003 server, so just started to find out about pgsql
Not sure what version of pgsql is running on the linux box.  This a library 
application written in php?.

I have just installed php v5.0.0 and postgresql v 8.0.1 on the Windows 2003 
server and it is working.
I can use phppgadmin v 3.5.2  to login to the gpsql on the windows box.

I am also trying to use the PostgreSQL ODBC connector  to connect.

I am a MS SQL DBA, so know more on ms products.

Any recommendations on how to do this migration/upgrade ?

TIA

RajiA



---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[GENERAL] Database Name

2005-03-01 Thread Envbop
Hi

I've just inherited a PostgreSQL database, for which I do not have any
details of, like database name or the users.
This used to be a library database which was managed via a web page written
in php.
Its running on a Linux box.
The front end was also written in php. The original writers of this
application is no longer.

I've just started to get familiarisd with postgresql in the last week. and
have installed PostgreSQL v8.0.1 on a Windows server.
And I am trying to connect to the linux box via the phppgadmin tool. as well
as trying an odbc connection.

Can someone tell me where I can find the database names.



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster