Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    38

    Angry Unanswered: Pg8.0 win32 and backup Problem

    Dear All,

    I'm working with PostgreSQL 8.0 Win32 and Borland C++ Builder.I'm having big troubles when transferring my whole data from server to home pc.I'm tired to having troubles with pg_dump+pg_restore+psql.I urgently need a stable backup/restore utility to transfer whole database system.
    When i was using mysql, i only zip database directory in ../mysql/data and extract to the same directory of home pc.That's it.But in postgresql, i'm tired with console application.Is there any instant solution for that?

    Analyzer

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    data dir

    zip the data directory and transfer it
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Apr 2004
    Posts
    38
    That's it??
    Humm, i didn't try it.I will try it on Monday.

    Analyzer

  4. #4
    Join Date
    Apr 2004
    Posts
    38
    Dear Eperich,

    Pity, It doesn't work.I'm using PG8.0 win32 and when i transfer old DATA directory to new server, server stops and does not work again.Then i uninstall whole server and install it back.
    Any other solutions?

    Analyzer

  5. #5
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    versions

    oh I thought you are trying to copy data from the same versions

    what goes wrong exactly with the dump ?
    are there error warnings?

    or try these (commercial)

    http://www.ems-hitech.com/pgsqlutils/
    Last edited by eperich; 08-24-04 at 05:38.
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •