On Sat, May 12, 2007 at 09:36:45AM -0400, Tom Allison wrote:
Meanwhile, can I just use pg_dumpall to pull from 8.1 and then reload
into 8.2?
http://www.postgresql.org/docs/faqs.FAQ.html#item3.6
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact
I'm trying to upgrade from 8.1 to 8.2.
Apparently the upgrade I just ran through installed a second database
on my server.
I was hoping that the debian configuration would migrate this for me.
I recall there was once a time when it would ask you about moving
data from old to new databases.
On Sat, May 12, 2007 at 09:36:45AM -0400, Tom Allison wrote:
I'm trying to upgrade from 8.1 to 8.2.
Apparently the upgrade I just ran through installed a second database
on my server.
I was hoping that the debian configuration would migrate this for me.
I recall there was once a time
Witam.
Proszę o pomoc z upgrade postgresa.
Mam zainstalowanego woody'ego. Na nim postgresa w wersji 7.2.1 - taki
jaki był w oryginale. Z pewnych względów spróbowałem go zuphradeować do
wersji 7.3 (robiąc to poprzez ściągnięcie pakietów z sarge'a). Niestety
automatyczny upgrade baz się nie
Użytkownik vaxio napisał:
Niestety automatyczny upgrade baz się nie udał. OCzywiście zachowana została
kopia baz - w katalogu /var/lib/postgres/preserve.
Może jakiś komunikat?
Wróciłęm z wersją do 7.2 poprzez odinstalowanie 7.3i zainstalowanie na
nowo 7.2. Potem wgrałem wszystko z katalogu
Nie czytalem co bylo wczesniej - ale ogolnie upgradowanie postgresa mam juz
opanowane na pamiec. Co kazda nowa wersja automatyczny upgrade sie nie powodzi
- jest po prostu sp :(
Ogolnie najlepiej zrobic dumpa calosci przed upgradem (nie tylko bazy)
/usr/lib/postgresql/bin/pg_dumpall.
Jesli
Użytkownik Adrian Siemieniak napisał:
ps. Panie [EMAIL PROTECTED] - NIE USTAWIAJ POLA REPLYTO!
Miałem nie ustawiać ale ustawiłem :P
... z rozpędu.
Już nie mam.
Marcin
On Thu, 2003-11-20 at 16:23, Monique Y. Herman wrote:
On Thu, 20 Nov 2003 at 02:50 GMT, Henry Hollenberg penned:
Hello,
I have a database running on potato using postgres 6.5 that I'd like
to upgrade to Woody running postgres 7.2.
...
I believe the install notes say, somewhere, that
On Wed, Nov 19, 2003 at 06:50:19PM -0800, Henry Hollenberg wrote:
The docs seem to imply that upgrading with this big a jump from
6.5 to 7.2 is dangerous.even if I do it by hand like so:
pg_dump mydatabase dump.mydatabase
destroydb mydatabase
upgrade the database system to 7.2
On Thu, 20 Nov 2003 at 02:50 GMT, Henry Hollenberg penned:
Hello,
I have a database running on potato using postgres 6.5 that I'd like
to upgrade to Woody running postgres 7.2.
The docs seem to imply that upgrading with this big a jump from 6.5 to
7.2 is dangerous.even if I do it by
Hello,
I have a database running on potato using postgres 6.5 that
I'd like to upgrade to Woody running postgres 7.2.
The docs seem to imply that upgrading with this big a jump from
6.5 to 7.2 is dangerous.even if I do it by hand like so:
pg_dump mydatabase dump.mydatabase
destroydb
Hello,
I have a database running on potato using postgres 6.5 that I'd like to upgrade to
Woody running postgres 7.2.
The docs seem to imply that upgrading with this big a jump from 6.5 to 7.2 is
dangerous.even if I do it by hand like so:
pg_dump mydatabase dump.mydatabase
destroydb
On Thu, Dec 05, 2002 at 05:26:33PM +0100, Bruno Boettcher wrote:
Hello
i got used to the automatic postgres upgrade... and stopped making
myself dumps before upgrading... :(
and now i am stuck.. the automatic upgrade failed, and i don't know
how to get this back...
i tried
Hello
i got used to the automatic postgres upgrade... and stopped making
myself dumps before upgrading... :(
and now i am stuck.. the automatic upgrade failed, and i don't know
how to get this back...
i tried the migration file, but couldn't get something usable out of
it...
postgresql
On Sun, Feb 17, 2002 at 01:38:52 +0100, Andreas Goesele wrote:
I now did a new try, again without any success. The automatic
upgrading process first looks promising but than ends with the
following error message:
You are now connected to database template1 as user user.
create database user;
On Sun, 2002-02-17 at 14:20, J.H.M. Dassen (Ray) wrote:
On Sun, Feb 17, 2002 at 01:38:52 +0100, Andreas Goesele wrote:
So I did read README.Debian.migration.gz and then run postgresql-dump
with the options in the README. This is what I got:
Stopping and restarting the postmaster
J.H.M. Dassen (Ray) [EMAIL PROTECTED] writes:
Switch back to the pg_hba.conf file you used with 6.5. 7.1 has a new
authentication method peer which 6.5 doesn't understand and which 7.1's
default configuration employs IIRC.
This helped. Thanks. But now I have a new problem: The encoding of my
Andreas Goesele [EMAIL PROTECTED] writes:
J.H.M. Dassen (Ray) [EMAIL PROTECTED] writes:
Switch back to the pg_hba.conf file you used with 6.5. 7.1 has a new
authentication method peer which 6.5 doesn't understand and which 7.1's
default configuration employs IIRC.
This helped. Thanks.
Hi,
Short story: Is there an easy way to upgrade from postgresql 6.5 to
7.1? An easy to follow document explaining how to do it?
Long story: Many tries, no success:
I have a nicely working postgresql 6.5 on Debian woody. When I first
upgraded to woody I too tried to upgrade to postgresql 7.1,
I'm trying to upgrade my version of postgres from 6.3 to 6.4 and
following the instructions in
/usr/doc/postgresql/README.Debian.migration.gz, I use the following
command as user postgres:
$ which postgresql-dump
/usr/lib/postgresql/bin/postgresql-dump
$ postgresql-dump -t db.out -ucil
The
20 matches
Mail list logo