473,226 Members | 1,324 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,226 software developers and data experts.

access xp postgres data from linux


I run an xp program in vmware that uses a postgresql db. I want to back
up this db from linux. The cmd I was given to backup the db from within
xp is:

pg_dump.exe -i -h <server> -p <port> -U <user> -F c -v -f <filename> <DB Name>

If xp/vwmare is not running and I mount the disc the xp postgresql data is
on and do:

/bin/su - mike -c "/usr/bin/postmaster -D /mnt/win_d/Program\ Files/PostgreSQL/8.0/data"

so that the linux postgresql is pointing to the xp data, what do I use for
"-h <server>" and "-p <port>" in the pg_dump cmd?

Mike
--
Aug 30 '05 #1
1 1960
In article <m2hdd884v6.fsf@west_f1.net>,
Mike Ballard <dont_w@nt_spam.org> wrote:
I run an xp program in vmware that uses a postgresql db. I want to back
up this db from linux. The cmd I was given to backup the db from within
xp is:

pg_dump.exe -i -h <server> -p <port> -U <user> -F c -v -f <filename> <DB
Name>

If xp/vwmare is not running and I mount the disc the xp postgresql data is
on and do:

/bin/su - mike -c "/usr/bin/postmaster -D /mnt/win_d/Program\
Files/PostgreSQL/8.0/data"

so that the linux postgresql is pointing to the xp data, what do I use for
"-h <server>" and "-p <port>" in the pg_dump cmd?

Mike
--


I never mix databases between operating systems. I have found in most
projects, it is very rare for branches of code that are OS dependent to
be up to date concurrently.

I would have a database for XP and a database for Linux.

--
Available for Hire! http://amduus.com/Resumes/
Aug 30 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Anthony Ewell | last post by:
Hi All, I am in the unique situation of designing a new Red Hat 9 server to run a Postgres database in a small company. The database that is being converted is currently 30 MB. There will be...
8
by: wlcna | last post by:
mysql v4.0.16: I had been using mysql with innodb and thought that was fine, until i used it for something requiring a few - perhaps slightly involved - joins, and have now seen the performance...
3
by: N.K. | last post by:
Hi, I've just installed postgres on the Linux server. It is supposed to start automatically which I think it does since I can run an sql stmt right away. When I'm trying to connect from a remote...
4
by: Ashwin Kutty | last post by:
Hi all, I sent this message to the jdbc list and received no response there and so am posting to this list hoping I could get some help here. Thanks in advance. ---------- Forwarded message...
3
by: Gaetano Mendola | last post by:
I found this article: http://www.serverwatch.com/news/article.php/10824_1126981_Ext that is clear out dated, it's anyway a good comparison with mysql. Do you know if someone did the TPC-C...
0
by: Jesse | last post by:
Hi all, I need some help with Access database and Postgres Database i am trying to link some Acces tables to Postgres tabels but id doesn't seem to work. I have a Postgres running on a server...
3
by: warwick.poole | last post by:
I am interested in finding out about Enterprise scale Postgres installations and clustering, especially on Linux. Essentially I would like to know the possibility that Postgres can store the...
3
by: Bernhard Ankenbrand | last post by:
Hi, we have a table width about 60.000.000 entrys and about 4GB storage size. When creating an index on this table the whole linux box freezes and the reiser-fs file system is corrupted on not...
9
by: Reid Priedhorsky | last post by:
Hi folks, I would like to access a remote Postgres server from a Python program in a secure way. Postgres doesn't currently listen to the Internet for connections, and I'd prefer to keep it that...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.