Scott Ribe escribió:
> > To be clearer: Do you mean that the folder you backed up is the folder
> > with the file "PG_VERSION" in it, and all its contents?
>
> In my case, yes, because I can copy the config files as well. In general, I
> was thinking of the folder passed to postmaster via -D. But
> To be clearer: Do you mean that the folder you backed up is the folder
> with the file "PG_VERSION" in it, and all its contents?
In my case, yes, because I can copy the config files as well. In general, I
was thinking of the folder passed to postmaster via -D. But of course if you
don't want to
Craig Ringer writes:
> To be clearer: Do you mean that the folder you backed up is the folder
> with the file "PG_VERSION" in it, and all its contents?
Careful --- there are multiple PG_VERSION files scattered around in a
Postgres data directory tree. Your comment is correct with respect
to the
Scott Ribe wrote:
You mean rsync the "data" folder, or the entire PG folder?
I meant the data folder.
To be clearer: Do you mean that the folder you backed up is the folder
with the file "PG_VERSION" in it, and all its contents?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql
Alban Hertroys, 24.07.2009 13:07:
It would be nice if there were a tool that could do a diff between two
dumps resulting in a new dump with just the statements necessary to
apply the differences. I don't think there is such a tool yet though
(some light Googling does bring up such a tool for sq
On 29 Jun 2009, at 6:10, Phoenix Kiula wrote:
Hi
We're trying PG on a new machine, so we copied our current (live)
database to that server. Tested the code and it's all working. Now, to
make that second server the main live server, we will need to copy the
db again including the new records sin
> You mean rsync the "data" folder, or the entire PG folder?
I meant the data folder.
> Will this be a challenge?
Yes, if you're using different major PG releases, then the data files are
not binary compatible.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567
On Tue, Jun 30, 2009 at 11:21 PM, Scott Ribe wrote:
> Shut down the postmasters and rsync. (Assuming same architecture & build
> options...)
>
You mean rsync the "data" folder, or the entire PG folder?
Architecture may be the same (same processor) but the setup is a touch
different: SCSI hard d
Shut down the postmasters and rsync. (Assuming same architecture & build
options...)
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
On Jun 29, 1:10 pm, phoenix.ki...@gmail.com (Phoenix Kiula) wrote:
> Hi
>
> We're trying PG on a new machine, so we copied our current (live)
> database to that server. Tested the code and it's all working. Now, to
> make that second server the main live server, we will need to copy the
> db again
Hi
We're trying PG on a new machine, so we copied our current (live)
database to that server. Tested the code and it's all working. Now, to
make that second server the main live server, we will need to copy the
db again including the new records since we copied for testing. Is
there any way to cop
11 matches
Mail list logo
