[mb-devel] Importing database

[Daniel Winter]

OK so we got 8.1.3 installed and all is fine. I am now just running the
replication changes.

What I forgot was the derived data, since I also wanted albummeta. Is it
still possible to import the fullexport dump of mbdump-derived AFTER the
main import and relication changes? If so, how do I go about it?

Thanks,
~Daniel
 

> -----Original Message-----
> From: musicbrainz-devel-bounces at zim.musicbrainz.org 
> [mailto:musicbrainz-devel-bounces at zim.musicbrainz.org] On 
> Behalf Of Daniel Winter
> Sent: Thursday, 30 March 2006 10:10 p.m.
> To: 'MusicBrainz development list'
> Subject: RE: [mb-devel] Importing database
> 
> Hmm! It's actually 7.3.10. I would have thought the latest would be
> installed, this one seems quite random, (I don't do software installs
> myself). Will get a more recent one on tomorrow.
> 
> What version is recommended? Is 8.1.3 known to work OK?
> 
> ~Daniel
> 
> > -----Original Message-----
> > From: musicbrainz-devel-bounces at zim.musicbrainz.org 
> > [mailto:musicbrainz-devel-bounces at zim.musicbrainz.org] On 
> > Behalf Of Steve Wyles
> > Sent: Thursday, 30 March 2006 10:04 p.m.
> > To: MusicBrainz development list
> > Subject: RE: [mb-devel] Importing database
> > 
> > 
> > Strange! Which version of PostgreSQL are you using?
> > 
> > Steve (inhouseuk)
> > 
> > 
> > On Thu, 30 Mar 2006, Daniel Winter wrote:
> > 
> > > It died.
> > >
> > > Thu Mar 30 21:39:32 2006 : CREATE INDEX
> > > Thu Mar 30 21:39:32 2006 :
> > > 
> > 
> psql:/home/httpd/musicbrainz/mb_server/admin/sql/CreateIndexes.sql:44:
> > > ERROR:  data type integer[] has no default operator class 
> > for access method
> > > "btree"
> > > Thu Mar 30 21:39:32 2006 :      You must specify an 
> > operator class for the
> > > index or define a
> > > Thu Mar 30 21:39:32 2006 :      default operator class for 
> > the data type
> > > Error during sql/CreateIndexes.sql at ./admin/InitDb.pl line 72.
> > > Thu Mar 30 21:39:32 2006 : InitDb.pl failed
> > >
> > > :(
> > >
> > >
> > >
> > >> -----Original Message-----
> > >> From: musicbrainz-devel-bounces at zim.musicbrainz.org
> > >> [mailto:musicbrainz-devel-bounces at zim.musicbrainz.org] On
> > >> Behalf Of Daniel Winter
> > >> Sent: Thursday, 30 March 2006 9:20 p.m.
> > >> To: 'MusicBrainz development list'
> > >> Subject: RE: [mb-devel] Importing database
> > >>
> > >> There was 11MB of disk space free, so changed the tmp to
> > >> another drive just
> > >> in case. It turned out to be DBD-Pg 1.47, had 1.32 installed
> > >> and now it's
> > >> importing successfully.
> > >>
> > >> Thanks for the help guys.
> > >>
> > >> ~Daniel
> > >>
> > >>
> > >>> -----Original Message-----
> > >>> From: musicbrainz-devel-bounces at zim.musicbrainz.org
> > >>> [mailto:musicbrainz-devel-bounces at zim.musicbrainz.org] On
> > >>> Behalf Of Dave Evans
> > >>> Sent: Thursday, 30 March 2006 6:38 p.m.
> > >>> To: MusicBrainz development list
> > >>> Subject: Re: [mb-devel] Importing database
> > >>>
> > >>> On Thu, Mar 30, 2006 at 04:27:32PM +1200, Daniel Winter wrote:
> > >>>> server closed the connection unexpectedly
> > >>>
> > >>> OK, so is anything helpful in the postgres server log?  (That
> > >>> is, /if/ your
> > >>> postgres server keeps logs.  Some don't).  Most obvious
> > >>> possible cause would
> > >>> be running out of disk space.
> > >>>
> > >>> --
> > >>> Dave Evans
> > >>>
> > >>> PGP key: http://rudolf.org.uk/pgpkey
> > >>> _______________________________________________
> > >>> MusicBrainz-devel mailing list
> > >>> MusicBrainz-devel at lists.musicbrainz.org
> > >>> http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-devel
> > >>>
> > >>>
> > >>
> > >> _______________________________________________
> > >> MusicBrainz-devel mailing list
> > >> MusicBrainz-devel at lists.musicbrainz.org
> > >> http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-devel
> > >>
> > >>
> > >
> > > _______________________________________________
> > > MusicBrainz-devel mailing list
> > > MusicBrainz-devel at lists.musicbrainz.org
> > > http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-devel
> > >
> > _______________________________________________
> > MusicBrainz-devel mailing list
> > MusicBrainz-devel at lists.musicbrainz.org
> > http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-devel
> > 
> > 
> 
> _______________________________________________
> MusicBrainz-devel mailing list
> MusicBrainz-devel at lists.musicbrainz.org
> http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-devel
> 
>