Re: Moving a PostgreSQL database from one server to another

From: Rodolfo J. Paiz (rpaiz_at_simpaticus.com)
Date: 01/13/05

  • Next message: Sven Borkert: "Re: FC3: Cyrus-IMAPD. Sieve authentication does not work" 
    To: For users of Fedora Core releases <fedora-list@redhat.com>
Date: Thu, 13 Jan 2005 16:15:37 -0600

    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.

    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>
-- 
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list
  • Next message: Sven Borkert: "Re: FC3: Cyrus-IMAPD. Sieve authentication does not work"

    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)
    • Re: Problem with dump on a DAT drive with 5.2.1 RELEASE.
      ... >> successfully rewinds the tape. ... >> I have been using the default tape device for mt commands, ... I needed to use the "mt eod" command to ... reposition the tape for the next dump. ...
      (comp.unix.bsd.freebsd.misc)
    • Re: Does System command pipe VI bufferizes data?
      ... apparently with system commands there is no problem in reading. ... the second question, you say that psql doesn't work. ... It seems to enter a wait state while the pipe is open. ...
      (comp.lang.labview)
    • Re: Simple BSD Backup System
      ... I think that FreeBSD is great, ... exactly the same thing as partimage, that is read the filesystem and backup ... The basic usage to dump and restore through a pipe is ... Then you can stack all sorts of commands such as gzip, rsh or ssh in the pipe ...
      (comp.unix.bsd.freebsd.misc)
    • SUMMARY: Problems with restore after installing PK8
      ... Create a Tar header with your fstab, sysconfig, and dump and restore ... Then you can just tar xvf the header and any files required for the restore, ... We ended up actually doing the former, but placed it on a modified version of the OS Boot CD so as not to confuse our users with tape commands. ...
      (Tru64-UNIX-Managers)