×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Copy Database from Linux to Windows

Copy Database from Linux to Windows

Copy Database from Linux to Windows

(OP)
Hi,

I've been asked to help out in attempting to retrieve some data from a PostgreSQL server that was based in a linux environment. All I've been told is that there is a problem with booting up the machine so that it can't even get past the boot up screen.

What I would like to to (if possible) is to take the hard disk out of the server and add it into one of our windows machines in order to examine the files. I would then (in theory) extract the database files, create a PostgreSQL server on Windows and then load the database onto the server to examine the data in the database.

Does anyone know if this is even possible, and if so what would I need to look for on the disk in order to extract the database?

Thanks,
Mark

Mark,

Darlington Web Design    |    Experts, Information, Ideas & Knowledge    |    ASP.NET Tips & Tricks

RE: Copy Database from Linux to Windows

Hi

All data is stored in a directory. The usual default is /var/lib/pgsql/data/ , but that can be changed. See the PostgreSQL init script, the directory should be passed to pg_ctl in its -D parameter.

The content of that directory is meaningful only for the PostgreSQL server, you can not extract the data without the server. No idea if a PostgreSQL for Windows can also handle those data, so I would do a backup copy first.
 

Feherke.
http://free.rootshell.be/~feherke/

RE: Copy Database from Linux to Windows

I woulnd't expect windows to be able to read the filesystem. Maybe it is an ext2-filesystem, where Windows-drivers exist, but not out of the box, to read it. But for reiserfs - are there windows-drivers to read them? Maybe it is even another filesystem.

However, if you put the drive into the windows-machine, which might happen to have a cd-drive, then you can download a linux-live-cd, burn it, and install - sorry - and boot the linux-live system, from which you can access the filesystem from the linux-machine.  

don't visit my homepage: http://home.arcor.de/hirnstrom/minis/index.html

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close