help on automatically running sql files

Discussion:

(too old to reply)

Pradeepkumar, Pyatalo (IE10)

2004-08-31 07:33:40 UTC

Hi all,
For the project that I am working on , we are using Postgresql 7.4.3 on
Linux 7.2. We have all the database tables,triggers and stored procedures as
seperate .sql files which we want to ship as part of our software. Now when
the user installs our software, we need to check if postmaster service is
running or not and if it is running, then we have to run the sql files
automatically. Can anyone help me out on how to run the .sql files
automatically.

With Best Regards
Pradeep Kumar P J

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Scott Marlowe

2004-08-31 07:57:04 UTC

Permalink

Post by Pradeepkumar, Pyatalo (IE10)
Hi all,
For the project that I am working on , we are using Postgresql 7.4.3 on
Linux 7.2. We have all the database tables,triggers and stored procedures as
seperate .sql files which we want to ship as part of our software. Now when
the user installs our software, we need to check if postmaster service is
running or not and if it is running, then we have to run the sql files
automatically. Can anyone help me out on how to run the .sql files
automatically.

Something like psql dbname <sqlfile.sql will do. If psql isn't in the
path, then /path/to/psql dbname <sqlfile.sql

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Pradeepkumar, Pyatalo (IE10)

2004-08-31 08:40:26 UTC

Permalink

Post by Pradeepkumar, Pyatalo (IE10)
Hi all,
For the project that I am working on , we are using Postgresql 7.4.3 on
Linux 7.2. We have all the database tables,triggers and stored procedures

Post by Pradeepkumar, Pyatalo (IE10)
seperate .sql files which we want to ship as part of our software. Now

when

Post by Pradeepkumar, Pyatalo (IE10)
the user installs our software, we need to check if postmaster service is
running or not and if it is running, then we have to run the sql files
automatically. Can anyone help me out on how to run the .sql files
automatically.

Something like psql dbname <sqlfile.sql will do. If psql isn't in the
path, then /path/to/psql dbname <sqlfile.sql

Hi Scott,
What we really require is, if we ship the .sql files as part of our software
package, the user should not do anything. The software when it installs
should automatically run the .sql files without the user intervention. We
dont want the user to check for the .sql files and run the above command
himself. We want to automate that in our software. Is that possible in
postgresql. If yes, how to do it. If no, is there any alternative solution.
I can think of one alternative that is to write a shell script.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Scott Marlowe

2004-08-31 09:14:07 UTC

Permalink

Post by Scott Marlowe

Post by Pradeepkumar, Pyatalo (IE10)
Hi all,
For the project that I am working on , we are using Postgresql 7.4.3 on
Linux 7.2. We have all the database tables,triggers and stored procedures

Post by Pradeepkumar, Pyatalo (IE10)
seperate .sql files which we want to ship as part of our software. Now

when

Something like psql dbname <sqlfile.sql will do. If psql isn't in the
path, then /path/to/psql dbname <sqlfile.sql
Hi Scott,
What we really require is, if we ship the .sql files as part of our software
package, the user should not do anything. The software when it installs
should automatically run the .sql files without the user intervention. We
dont want the user to check for the .sql files and run the above command
himself. We want to automate that in our software. Is that possible in
postgresql. If yes, how to do it. If no, is there any alternative solution.
I can think of one alternative that is to write a shell script.

That's pretty much what I was thinking when I made my suggestion.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Gémes Géza

2004-08-31 10:09:35 UTC

Permalink

Post by Scott Marlowe

Post by Pradeepkumar, Pyatalo (IE10)
Hi all,
For the project that I am working on , we are using Postgresql 7.4.3 on
Linux 7.2. We have all the database tables,triggers and stored procedures

Post by Pradeepkumar, Pyatalo (IE10)
seperate .sql files which we want to ship as part of our software. Now

when

Something like psql dbname <sqlfile.sql will do. If psql isn't in the
path, then /path/to/psql dbname <sqlfile.sql
Hi Scott,
What we really require is, if we ship the .sql files as part of our software
package, the user should not do anything. The software when it installs
should automatically run the .sql files without the user intervention. We
dont want the user to check for the .sql files and run the above command
himself. We want to automate that in our software. Is that possible in
postgresql. If yes, how to do it. If no, is there any alternative solution.
I can think of one alternative that is to write a shell script.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org

Your software installs somehow. Posibilities:
-Via a shell/perl install script: append at the end of the script
- Via a graphical install programm: append at the end of the programs
main part as the last thing to do (easiest way (but less performant):
via an exec statement)
- Via rpm/deb/whatever else: In this case the packager usualy have a
postinstall part, where you can put this script, which checks for the
runing postgresql instance, and then run the required .sql files

Regards,

Geza Gemes