Replication again
Does anyone know a good commercial application that does multi-master replication for postgres?
Thanks
Hi there,
I'm trying to access my postgreSQL database using Excel (through MS
Query). I've been reading a bit about ODBC and I'm pretty sure that
this is required. Is there a way to see if this is set up already? Am
I on the right track? The database server is running redhat linux.
Any help would be appreciated...
Thanks,
Grant
--
Grant Rutherford
Iders Incorporated
600A Clifton Street
Winnipeg, MB
R3G 2X6
http://www.iders.ca
tel: 204-779-5400 ext 36
fax: 204-779-5444
================================
Iders Incorporated: Confidential
================================
Note: This message is intended solely for the use of the designated
recipient(s) and their appointed delegates, and may contain
confidential information. Any unauthorized disclosure, copying or
distribution of its contents is strictly prohibited. If you have
received this message in error, please destroy it and advise the sender
immediately by phone, Email or facsimile.
Hello,
Yes ODBC will be required and unless you have installed it is not
configured. You can go
here:
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php
For the OpenSource/Free version or here:
For a commercial (with more features) version.
Sincerely,
Joshua D. Drake
Grant Rutherford wrote:
Hi there,
I'm trying to access my postgreSQL database using Excel (through MS
Query). I've been reading a bit about ODBC and I'm pretty sure that
this is required. Is there a way to see if this is set up already?
Am I on the right track? The database server is running redhat linux.Any help would be appreciated...
Thanks,
Grant
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org 
I'll assume you are on a Windows box. The answer is yes, you can use Excel
to pull back data from a Pg database on a Linux box.
If you are planning to use MS Query and If you don't have MS Query
installed, you will need to install from the disk.
You can download the Pg ODBC driver from the Pg site. Just click on the
download link, select your country, and then navigate to the ODBC/Versions
folder. You'll want to download the 7.03.02 version as this is the newest.
Then create the DSN - do a Google search on how to do this if you don't
know how.
Then fire up Excel and from the menu select Data, Get External Data, New
Database Query. Follow the wizard from there.
hth
Patrick
***You wrote****
Hi there,
I'm trying to access my postgreSQL database using Excel (through MS
Query). I've been reading a bit about ODBC and I'm pretty sure that
this is required. Is there a way to see if this is set up already? Am
I on the right track? The database server is running redhat linux.
Any help would be appreciated...
Thanks,
Grant
Import Notes
Resolved by subject fallback
Patrick Hatcher wrote:
I'll assume you are on a Windows box. The answer is yes, you can use Excel
to pull back data from a Pg database on a Linux box.
If you are planning to use MS Query and If you don't have MS Query
installed, you will need to install from the disk.
You can download the Pg ODBC driver from the Pg site. Just click on the
download link, select your country, and then navigate to the ODBC/Versions
folder. You'll want to download the 7.03.02 version as this is the newest.
Then create the DSN - do a Google search on how to do this if you don't
know how.
Then fire up Excel and from the menu select Data, Get External Data, New
Database Query. Follow the wizard from there.hth
Patrick***You wrote****
Hi there,
I'm trying to access my postgreSQL database using Excel (through MS
Query). I've been reading a bit about ODBC and I'm pretty sure that
this is required. Is there a way to see if this is set up already? Am
I on the right track? The database server is running redhat linux.Any help would be appreciated...
Thanks,
Grant---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
If you are just running the occasional query and want the results placed
into an Excel spreadsheet, you should look at pgAdmin. You run it from
your windows box and you can run queries and have the results displayed
-> on screen, ->written to a file, ->or to an Excel spreadsheet. The
latest version also runs on linux. You can find it here:
http://www.pgadmin.org/pgadmin3/index.php
Ron
Ron wrote:
...
If you are just running the occasional query and want the results placed
into an Excel spreadsheet, you should look at pgAdmin. You run it from
your windows box and you can run queries and have the results displayed
-> on screen, ->written to a file, ->or to an Excel spreadsheet. The
latest version also runs on linux. You can find it here:
This is only true for PGAdmin2, not 3.
3 is a complete rewrite and will later have
different tools for generating files then
PgAdmin2 has today.
Regards
Tino
On Mon, Oct 27, 2003 at 10:10:02AM -0600, Chris M. Gamble wrote:
Does anyone know a good commercial application that does
multi-master replication for postgres?
No, but if you find one, please tell me.
What is it you're trying to do exactly? Multi-master replication is
typically very difficult, prone to lock up, and usually _very_
expensive. But there are probably some tricks to accomplish some
kinds of tasks if you want them to be done.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110