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;19884 Wrote:
> 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
Magic31’s Profile: http://forums.suse.com/member.php?userid=73
View this thread: http://forums.suse.com/showthread.php?t=4269
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