packages/libs/postgresql/files, branch master

postgresql: fix fails to start on mounted data directories

2025-10-25T05:37:54Z

This commit resolves a bug where the PostgreSQL service failed to start during the boot process when its data directory ($pgdata) was on a partition mounted via `/etc/fstab`. Because the filesystem is already mounted, no hotplug event is ever triggered, and the PostgreSQL service mistakenly waits for an event that will never happen. This fix adds a check to ensure the script does not skip starting the service if the data directory is on a mount point. Signed-off-by: Peiying Huang

postgresql: improve init script

2021-08-12T02:11:09Z

Use newly introduced procd_add_restart_mount_trigger to make sure postmaster gets started only once PGDATA becomes available. Relocate socket directory to /var/lib/postgresql to make it possible to run postgresql inside a ujail. Use signal for shutdown, so it works nicely with jail. Allow multiple script in UCI 'config postgres-db' to be a list and run them in order listed. User more silent methods to check for db or role existence and make it easy to create several databases owned by the same user by passing the same credentials multiple times. Remove disfunctional reload handler. Signed-off-by: Daniel Golle

treewide: fix service status command in procd compatible services

2019-11-18T05:28:57Z

Fix breaking change introduced in the main tree with a commit 7519a36774ca ("base-files,procd: add generic service status") where the old service `status` callback function doesn't work anymore and needs to be renamed to `status_service`. This name was chosen for consistency with start and stop function callbacks, which are using `start_service` and `stop_service` naming schemes. While at it, fix whitespace issues in the status_service as well. Ref: http://lists.infradead.org/pipermail/openwrt-devel/2019-September/019035.html Reported-by: Dirk Brenken Signed-off-by: Petr Štetiar

postgresql: allow populating required DB using script

2017-07-02T17:57:31Z

Extend UCI mechanics to allow pre-populating a newly created database by executing SQL statements from a scripts file. Signed-off-by: Daniel Golle

postgresql: properly stop service

2016-10-10T23:03:27Z

postmaster always detaches from procd, work around by using pg_ctl to stop the server. Signed-off-by: Daniel Golle

postgresql: update to version 9.5.4 and major rework

2016-09-23T18:03:05Z

* convert package build to use host-build for ecpg, pg_config and zic * introduce /lib/functions/postgresql.sh to be used by packages requiring a postgres database to exist as well as postgres' init * no longer require shadow-su, patch pg_ctl to setuid() ifself instead * auto-create database directory if there is enough free space * auto-create databases configured in UCI * remove some dead uci config options * grab maintainership Signed-off-by: Daniel Golle

postgresql: update source to 9.4.4 and refresh scripts

2015-08-12T15:30:20Z

Signed-off-by: Daniel Golle

postgresql: import from oldpackages, add myself as maintainer, add license information, update to v9.0.17

2014-07-02T10:42:33Z

Signed-off-by: Jo-Philipp Wich