PDA

View Full Version : Database setup in SUSEStudio



DocB
13-Mar-2014, 16:36
Hi all,

SUSEStudio offers the option to set up a postgres-database. According to
the documentation, I have created a dump of the database and bz2'd it:
gnuhealth24.sql.bz2
I set up the users and authorisations in Studio. When I build and run
the appliance, and issue the command:
su postgres
psql gnuhealth24

This results in an error 'database does not exist'.

Any idea how to fix this?

(This question was posted in teh SUSEStudio Forum as well)


--
DocB
------------------------------------------------------------------------
DocB's Profile: http://forums.opensuse.org/member.php?userid=574
View this thread: http://forums.opensuse.org/showthread.php?t=496206

Magic31
14-Mar-2014, 09:31
Hi all,

SUSEStudio offers the option to set up a postgres-database. According to
the documentation, I have created a dump of the database and bz2'd it:
gnuhealth24.sql.bz2
I set up the users and authorisations in Studio. When I build and run
the appliance, and issue the command:
su postgres
psql gnuhealth24

This results in an error 'database does not exist'.

Any idea how to fix this?

(This question was posted in teh SUSEStudio Forum as well)


--


Hi Doc,

I've only done this with MySQL so far... and that was nothing more than installing the packages in the appliance.
Then on a development system using the same versions of the mysql packages, built up the databases & users as needed and tar.zipped "/var/lib/mysql" preserving path, and finally add it to the appliance as files to be placed in the appliance.

Probably not as the documentation lays it out, but it has worked perfectly for two appliances I've built.

Cheers,
Willem

DocB
20-Mar-2014, 15:36
Hi Willem,

indeed, that is a very feasible way to get the database up and running.
After fiddeling around for some time with scripts after installation and
boot, that worked 'out of the box'.

Thanks a lot for the hint!
Axel


--
DocB
------------------------------------------------------------------------
DocB's Profile: http://forums.opensuse.org/member.php?userid=574
View this thread: http://forums.opensuse.org/showthread.php?t=496206