Hi!
I have PostgreSQL 7.4 DBM and want to upgrade to 8.2 (latest in version 8 I
quess).
Can use the DATADIR from 7.4 and just upgrade the DBM/postgresql server to 8.2?
Is the upgrade from 7 to 8 procedure written down somewhere? (could not find
anyting at http://www.postgresql.org/docs/techdocs
Hi Rickard!
As far as i know you will have to dump and restore the databases for the
upgrade since a lot of internals have been changed from 7.4 to 8.2.
A description on how to upgrade can be found here:
http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html
And here: http://www.pos
Dear Rickard,
The jump from 7.4 to 8.2 is rather big.
I would suggest doing just a dry run by dumping
the database schema without data and restoring it
into 8.2 database . this can be time saving in detecting
possible problems in migration.
in case there is some non trivial problem
you may take
I would like to know whether I can set DBmirror replication from the fedora core
5_64 which postgresql8.1 was installed by rpm process not by compiling the
source. All of the component include server, contrib, perl, test, doc, devel
and lib were also rpm and what is the way to set it?
Do I need to
Hi!
Thanks for your replies!
My problem is that I want to move the DBM to a different machine so now when it
doesn't seem to be any easy/trivial way to migrate from 7.4 to 8.2 I might
consider to continue with 7.4.
If I decide to continue with 7.4 I guess the procedure to move the DATADIR to
t
Hi all,
I've got a DB in production that is bigger than 2GB that dumping it
takes more than 12 hours. I have a new server to replace this old one
where I have restore the DB's dump. The problem is I can't afford to
have the server out of business for so long, so I need your advice about
how you
On Tue, 19 Dec 2006, Arnau wrote:
I've got a DB in production that is bigger than 2GB that dumping it
takes more than 12 hours. I have a new server to replace this old one
where I have restore the DB's dump. The problem is I can't afford to
have the server out of business for so long, so I need
Hi Jeff,
On Tue, 19 Dec 2006, Arnau wrote:
I've got a DB in production that is bigger than 2GB that dumping it
takes more than 12 hours. I have a new server to replace this old one
where I have restore the DB's dump. The problem is I can't afford to
have the server out of business for so long
On 12/19/06, Rickard Sjöström <[EMAIL PROTECTED]> wrote:
Hi!
Thanks for your replies!
My problem is that I want to move the DBM to a different machine so now when it
>doesn't seem to be any easy/trivial way to migrate from 7.4 to 8.2 I might
>consider to continue with 7.4.
It was not my inte
On Tue, 19 Dec 2006, Arnau wrote:
On Tue, 19 Dec 2006, Arnau wrote:
I've got a DB in production that is bigger than 2GB that dumping it
takes more than 12 hours. I have a new server to replace this old one
where I have restore the DB's dump. The problem is I can't afford to
have the server ou
On 12/19/06, Arnau <[EMAIL PROTECTED]> wrote:
Hi Jeff,
> On Tue, 19 Dec 2006, Arnau wrote:
>
>> I've got a DB in production that is bigger than 2GB that dumping it
>> takes more than 12 hours.
thats strange , we dump +20GB data in 2 hrs or so.
I have a new server to replace this old one
>>
I am getting ready to set up 2 postgres instances, but I'm somewhat new
to postgres. I've used RPM to list out all the files that are
installed, and I think I've isolated all the executables of which I need
to make separate copies, but I was hoping for some confirmation. I
heard the exact files t
On 12/19/06, Tom Kalafut <[EMAIL PROTECTED]> wrote:
I am getting ready to set up 2 postgres instances, but I'm somewhat new to
postgres. I've used RPM to list out all the files that are installed, and I
think I've isolated all the executables of which I need to make separate
copies, but I wa
After consulting with a teammate, I've found out that they'd have no
problem simply doing 2 separate makes. In fact, I'm glad. It's makes
much better sense.
Thanks,
Tom
Tom Kalafut
Interchange/CG Crew Member
Trident Systems Inc.
[EMAIL PROTECTED]
(919)388-1264
-
The op
On 12/20/06, Tom Kalafut <[EMAIL PROTECTED]> wrote:
After consulting with a teammate, I've found out that they'd have no
problem simply doing 2 separate makes.
In fact, I'm glad. It's makes
much better sense.
i really dont much understand what you have
decided to do. have you considered creat
That is not an option. We're currently doing that.
The customer wants separate installations of postgres, mostly for
security reasons. Admin is divvied up between 4-5 "admin" user accounts
on the system because there are several user roles in our product's
community. Separate installations allo
Very easy,
Install the new version of PostgreSQL on your new machine. Then use the new
machine's install to pg_dump the old machine's database and load it into the
new machine (obviously, the machines must be table to talk to each other
over the network). Very easy. That is how I upgraded all
One other option is to shut the database down competely, and then do a copy
of the file system the new server. I have done this when I need to move a
very large database to a new server. I can copy 500GB's in a couple of
hours, where restoring my large databases backups would take 10+ hours.
Jus
On Tue, 2006-12-19 at 16:40 -0500, Chris Hoover wrote:
> Very easy,
>
> Install the new version of PostgreSQL on your new machine. Then use
> the new machine's install to pg_dump the old machine's database and
> load it into the new machine (obviously, the machines must be table to
> talk to each
Στις Δευτέρα 18 Δεκέμβριος 2006 11:55, ο/η [EMAIL PROTECTED] έγραψε:
> I would like to know whether I can set DBmirror replication from the fedora
> core 5_64 which postgresql8.1 was installed by rpm process not by compiling
> the source. All of the component include server, contrib, perl, test, do
20 matches
Mail list logo