linux pg pointed to windows partition for db

From: "mike dixon" <mdixon(at)operamail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: linux pg pointed to windows partition for db
Date: 2005-09-11 17:36:26
Message-ID: 20050911173626.5BA727B49F@ws5-10.us4.outblaze.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tried a couple other places and aren't getting anywhere.

A windows xp program I use uses pgsql; I'd like to create a backup of the db but from within linux without xp running (I run xp in vmware; and the xp db backup will be written to an ext* partition). I have the same rev pgsql installed on xp and linux (8.0.3 IIRC); the xp/pgsql db is on an NTFS partition and I mount the disc read-only.

My problem is two-fold:

1. What parameters to start the linux pgsql with for this circumstance if not the defaults;

2. How to point the linux pgsql/pg_dump to the xp pg's data to do the backup.

Can I just start the linux pgsql with its defaults? If so, how do I point linux pg_dump to the pgsql db data in an xp dir ("/mnt/Program Files/Postgresql/8.0/data")?

If linux pgsql defaults aren't good enough for this circumstance, what do I need to change?

Also, if the xp pgsql db requires a pw when working with it under xp, if xp isn't running and I can use the linux pg_dump for this do I still need the xp pgsql pw? Is there any way to pass that to the linux pg_dump on the cmd line so I can put this operation in a script?

--
_______________________________________________
Surf the Web in a faster, safer and easier way:
Download Opera 8 at http://www.opera.com

Powered by Outblaze

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2005-09-11 20:25:15 Re: What happens when wal fails?
Previous Message Roman Neuhauser 2005-09-11 17:09:44 Re: arrays, composite types