Re: Moving a PostgreSQL database from one server to another

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

  • Next message: Tony Dietrich: "Re: How to improve performance? (starter)" 
    To: td@transoft.demon.co.uk, For users of Fedora Core releases <fedora-list@redhat.com>
Date: Thu, 13 Jan 2005 17:00:43 -0600

    On Thu, 2005-01-13 at 22:37 +0000, Tony Dietrich wrote:
    > On Thursday 13 Jan 2005 22:15, Rodolfo J. Paiz wrote:
    > > pg_dump runs for less than one second and then exits. No error is given,
    > > no output results, nothing.
    > >
    > 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.

    That step may not be necessary. The pg_dump man page states: "pg_dump is
    a utility for backing up a PostgreSQL database. It makes consistent
    backups even if the database is being used concurrently. pg_dump does
    not block other users accessing the database (readers or writers)." This
    implies to me that the database server does not need to be stopped.

    However, I subsequently decided that my interpretation could have been
    wrong and stopped the service, then repeated my attempts. Still no
    output of any kind, no errors, and no logs. Not even following the
    simple examples in the man page, stuff like "pg_dump database > file".
    So even if stopping the service is needed, I didn't skip it.

    Not trying to pound on your suggestion here, just providing as much data
    as I can to help diagnosis.

    Cheers, 

    -- 
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: Tony Dietrich: "Re: How to improve performance? (starter)"

    Relevant Pages

    • RE: How do I restore from mdf and ldf files?
      ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
      (microsoft.public.sharepoint.portalserver)
    • RE: ESENT Logging
      ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... newsgroups so that they can be resolved in an efficient and timely manner. ...
      (microsoft.public.windows.server.sbs)
    • RE: ESENT Logging
      ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
      (microsoft.public.windows.server.sbs)
    • RE: Backups have Shadow Copy Problems
      ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
      (microsoft.public.windows.server.sbs)
    • Re: Copying a database between servers
      ... In 2000 you can backup to an UNC path ... or a local drive and the same goes for the restore. ... backup the database and then restore it on the new server. ... >>> one SQL Server 7.0 database with 'select' access to another SQL ...
      (microsoft.public.sqlserver.tools)