Re: Moving a PostgreSQL database from one server to another

From: Les Mikesell (les_at_futuresource.com)
Date: 01/13/05

  • Next message: Rodolfo J. Paiz: "Re: Moving a PostgreSQL database from one server to another" 
    To: td@transoft.demon.co.uk, For users of Fedora Core releases <fedora-list@redhat.com>
Date: Thu, 13 Jan 2005 16:57:34 -0600

    On Thu, 2005-01-13 at 16:37, Tony Dietrich wrote:

    >
    > 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.

    pg_dump is the 'hot' database backup tool. It should be used with
    the server running. If the destination is the same CPU type you
    can get away with copying the files under /var/lib/pgsql/ instead,
    in which case the server must be shut down. You do have to tell
    it which database to dump and run it as a user with permission
    to connect, but there should be some kind of error message if
    it fails. 

    -- 
  Les Mikesell
   les@futuresource.com
-- 
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list
  • Next message: Rodolfo J. Paiz: "Re: Moving a PostgreSQL database from one server to another"

    Relevant Pages

    • Re: Moving a PostgreSQL database from one server to another
      ... it seems those are commands ... > to be typed in at the BASH shell, not inside psql... ... A running server hooks into the db and blocks the dump. ...
      (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: SQL Server 2005 hang up
      ... Tibor Karaszi, SQL Server MVP ... External dump process returned no errors. ... System Idle 99%. ...
      (microsoft.public.sqlserver.server)
    • 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)