pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alfred Lau - FORMotion Systems <alfred.lau@formotionsystems.com>
To: Jason Minion <jason.minion@sigler.com>
To: pgsql-admin@postgresql.org
Subject: Re: Transferring DATA directory
Date: Fri, 20 Jan 2006 09:47:12 -0500
Message-ID: <20060120144624.M57451@formotionsystems.com> (raw)
In-Reply-To: <0105A1BF505D304E9E5AF38B63E40E4ED7EBEC@EXCHANGE.siglercompanies.com>
References: <0105A1BF505D304E9E5AF38B63E40E4ED7EBEC@EXCHANGE.siglercompanies.com>

Hi Jason,

Permssions was the exact problem. After disabling the simple file sharing
option in Folder Options (under Windows XP Professional), I was able to see
the permissions of the DATA folder and change them appropriately.

Gracias,

Alfred.


On Wed, 18 Jan 2006 11:26:26 -0600, Jason Minion wrote
> Does the local postgresql user account on machine B have the correct
> permissions for the files you copied over? Also make sure to try
> starting postgresql from the command line using pg_ctl, and check 
> your service properties to get an idea of the command being used 
> there to attempt to start postgresql. Things like the "-D <path" 
> parameter will be *very* important.
> 
> Jason Minion
> 
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Alfred Lau -
> FORMotion Systems
> Sent: Wednesday, January 18, 2006 10:47 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Transferring DATA directory
> 
> Hi,
> 
> I'm trying to transfer large amounts of data between two PostgreSQL
> 
> 8.1.2 database Windows XP platforms using the physical filesystem backup
> method. I used the same PostgreSQL installer on both machines and the
> same PostgreSQL configuration. I also used default options with PostGIS
> options. I did the
> following:
> 
> 1.  shut down the database on each of machine A and machine B, 2.
> zipped up the <postgre-home>\DATA directory on machine A and 
> unzipped it onto machine B.
> 3.  when I started up PostgreSQL on machine B with machine A's data 
> directory, the following message is returned:
> 
> "The PostgreSQL Database Server 8.1 service could not be started.
> 
> The service did not report an error.
> 
> More help is available by typing NET HELPMSG 3534"
> 
> I'm trying not to transfer data using pg_dump as it's quite a lot of
> data and highly time consuming. Does anyone know if this is possible.
> I've verified that there is no .pid file in the DATA directory. Are
> there other files I am missing? Anything else I might try?
> 
> Thanks,
> 
> Alfred Lau
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings



Alfred Lau

Software Developer
FORMotion Systems Inc.
alfred.lau@formotionsystems.com




view thread (5+ messages)  latest in thread

Message-ID: <20060120144624.M57451@formotionsystems.com>
Permalink:  ../20060120144624.M57451@formotionsystems.com/
Also on:    postgresql.org/message-id/20060120144624.M57451@formotionsystems.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: alfred.lau@formotionsystems.com, jason.minion@sigler.com
  Subject: Re: Transferring DATA directory
  In-Reply-To: <20060120144624.M57451@formotionsystems.com>
  References: <0105A1BF505D304E9E5AF38B63E40E4ED7EBEC@EXCHANGE.siglercompanies.com> <20060120144624.M57451@formotionsystems.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox