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 t
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? Conta
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 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,
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 i
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
>
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 myda
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 mydata
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
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...
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.
>
> Thi
"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 encodin
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
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 u
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, bu
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 Postg
16 matches
Mail list logo