help with rpm script - Mailing list pgsql-sql

From Craig Jensen
Subject help with rpm script
Date
Msg-id 197752183853.20030701081749@acenet-tech.org
Whole thread Raw
List pgsql-sql
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 are the command functions I need to execute within the rpm...

# service postgresql start 
# su postgres 
# createdb account 
# psql account < my1.sql 
# psql account < my2.sql 
# exit 

But, I need these functions to be executed when someone installs my rpm. For Mysql, I have the following
in the %post of my spec file:

-------------------snippet-from-spec-file------------------------- 
%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 mydb 2>&1 &> /dev/null 
if [ "$?" = "1" ; then
/bin/echo "Creating mydb database..." 
/usr/bin/mysqladmin --password=$pw create mydb 
/bin/echo "grant all on mydb.* to dude@localhost identified by 'dudepass';" | /usr/bin/mysql --password=$pw 
/usr/bin/mysql --password=$pw mydb < /path/to/my.sql 
/usr/bin/mysqladmin --password=$pw reload 
fi 


--------------end-of-snippet-from-spec-------------------------- 
What commands could I use to complete similar needs for
a postgresql database to be created by an rpm?

Thank you for any 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.{{{




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Failed to initialize lc_messages to ''
Next
From: Bruno Wolff III
Date:
Subject: Re: help with "delete joins"