From: Craig Jensen <cjensen@acenet-tech.org>
To: pgsql-sql@postgresql.org
Subject: rpm scripts
Date: Fri, 13 Jun 2003 13:45:48 -0600
Message-ID: <423848393.20030613134548@acenet-tech.org> (raw)
Hello,
I am building an rpm for Mitle SME (a scaled down redhat 7.3) and
have all functions working except:
I need to have the rpm when installed create a database and a
user with privilege to that database. These commands are easy
enough in general...
# service postgresql start
# su postgres
# createdb account
# psql account < Pg-tables.sql
# psql account < US_General-chart.sql
# exit
But, I need these functions to be executed when one installs my rpm.
For Mysql, I have the following in the %post:
-------------------snippet-from-spec-------------------------------------------------------------------------------------
%post
# This section creates the database, dbuser, dbpasswd and data after the
# package has been installed
pw=`/bin/cat /etc/openldap/ldap.pw`
/bin/echo exit | /usr/bin/mysql --password=$pw catalog 2>&1 &> /dev/null
if [ "$?" = "1" ] ; then
/bin/echo "Creating catalog database..."
/usr/bin/mysqladmin --password=$pw create catalog
/bin/echo "grant all on catalog.* to catalog@localhost identified by 'shopuser';" | /usr/bin/mysql --password=$pw
/usr/bin/mysql --password=$pw catalog < /home/e-smith/files/primary/html/store/catalog/install/oscommerce.sql
/usr/bin/mysqladmin --password=$pw reload
fi
--------------end-of-snippet-from-spec-----------------------------------------------------------------------------------
This creates a database using the root pasword (Mitel SME keeps
this in ldap.pw (which is probably not needed for postgresql).
What commands would I use to complete similar needs for
a postgresql database to be created?
Thank you for the help.
--
Best regards,
Craig Jensen mailto:cjensen@acenet-tech.org
Ace Net-Tech
http://www.acenet-tech.org/ My computer services site.
http://www.acenet-tech.org/phpBB2/ My forum, business and otherwise.
}}}All ouotgoing messages scanned and verified virus-free by Norton Antivirus
2003.{{{
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cjensen@acenet-tech.org
Subject: Re: rpm scripts
In-Reply-To: <423848393.20030613134548@acenet-tech.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox