Thread: initskript after db start; locks on transactions

Hi!

I have have two questions:

1.
What is the best approach to trigger a service script wich will clean
up something in the db after every db (re-)start? Has PG its own
mechanism for such things or have i to use my /etc/init.d/postgresql
script?

2.
Sometime i read something about locks on transactions. Is this only an
internal thing or can i set them by my own and if yes, for what? With
the LOCK command i can only lock tables, or?

Thanks for any help,
Thomas!

On Aug 3, 2005, at 4:33 PM, Thomas Chille wrote:

> Hi!
>
> I have have two questions:
>
> 1.
> What is the best approach to trigger a service script wich will clean
> up something in the db after every db (re-)start? Has PG its own
> mechanism for such things or have i to use my /etc/init.d/postgresql
> script?

I don't think there's anything built in that will trigger a "service
script". I'm pretty sure you'll want to add to or supplement the
existing init script.

> 2.
> Sometime i read something about locks on transactions. Is this only an
> internal thing or can i set them by my own and if yes, for what? With
> the LOCK command i can only lock tables, or?

You can use any lock mode specified:

http://www.postgresql.org/docs/8.0/static/sql-lock.html

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source: Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)