Re: Moving a PostgreSQL database from one server to another

From: Tony Dietrich (td_at_transoft.demon.co.uk)
Date: 01/13/05

  • Next message: Tony Dietrich: "Re: Nervious wannabe new user asks for advice." 
    To: For users of Fedora Core releases <fedora-list@redhat.com>
Date: Thu, 13 Jan 2005 22:37:07 +0000

    On Thursday 13 Jan 2005 22:15, Rodolfo J. Paiz wrote:
    > On Thu, 2005-01-13 at 13:23 -0500, Scot L. Harris wrote:
    > > I think what you are looking for is the
    > >
    > > pg dump
    > >
    > > or
    > >
    > > pg dumpall
    > >
    > > commands.
    >
    > Fantastic. After some more thrashing around, it seems those are commands
    > to be typed in at the BASH shell, not inside psql... that had me fooled
    > for a little while. But I eventually managed to find "pg_dump",
    > "pg_dumpall" and "pg_restore". Great, says I.
    >
    > Nope. I've been through the pg_dump man page backwards and forwards and
    > have tried lots of iterations of the command. While the PostgreSQL
    > service is started, and I can access the database properly with psql,
    > pg_dump runs for less than one second and then exits. No error is given,
    > no output results, nothing.
    >
    > This is FC3, everything is updated, and I've tried setting every useful
    > parameter I can think of, even setting host, user, and -W to force a
    > password prompt. Nada, zilch, zippo. No logs anywhere I can find,
    > either. /var/log/pgsql is entirely empty.

    You missed a step the original reply stated.
    TURN OFF the PSQL server before dumping.
    A running server hooks into the db and blocks the dump.

    If you can't shutdown the server to do the dump on a production machine, you
    are limited to SQL to backup the data, assuming the remote server is
    available through the network. Look up how to use PSQL as a SRDBM.
    >
    > Since surely I'm not the first one to want a database backed up or
    > transferred to another server, anyone who got this working have any
    > suggestions?
    >
    > Thanks,
    >
    > --
    > Rodolfo J. Paiz <rpaiz@simpaticus.com> 

    -- 
Tony Dietrich
-------------
All art is but imitation of nature.
  -- Lucius Annaeus Seneca
-- 
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list
  • Next message: Tony Dietrich: "Re: Nervious wannabe new user asks for advice."

    Relevant Pages

    • Re: problem creating warm standby on 6.5
      ... I recommend that you use ISQLw and execute DUMP and LOAD ... Or you could run SQLTrace and catch the SQL commands issued by Enterprise ... >>Tibor Karaszi, SQL Server MVP ...
      (microsoft.public.sqlserver.server)
    • Re: Moving a PostgreSQL database from one server to another
      ... > pg dump ... it seems those are commands ... to be typed in at the BASH shell, not inside psql... ... parameter I can think of, even setting host, user, and -W to force a ...
      (Fedora)
    • rdump problem
      ... I am trying to rdump from server 2 to server1 and am getting ... rcmd: socket: Permission denied ... dump: Date of last level dump: the start of the epoch ...
      (Tru64-UNIX-Managers)
    • Re: MMC.exe stops responding for up to 5 minutes during AD GPO browse / edit
      ... > -The oldest file in the same folder on the test VPC server is 9/25/1999 ... >>> kernel dump it should show up. ... >>>> it may be our self and that it may be a filter driver in the kernel. ...
      (microsoft.public.windows.server.active_directory)
    • Re: Need Help Creating Memory.DMP File....
      ... If you make some registry adjustments, you can manaully trigger a memory ... dump using the keyboard when your system is hung/locked up. ... > DEFAULT Windows Server screensaver was locked in one position. ... If I have 'Automatically Restart' CHECKED, ...
      (microsoft.public.windows.server.general)