Lance Edgar
|
ae7cb45ab3
|
Remove bash -c prefix for pg_dump command
need to keep the `sudo -u postgres pg_dump ..` part as simple as
possible, since must declare `sudoers` allowance for that
|
2023-09-17 11:10:48 -05:00 |
|
|
Lance Edgar
|
24d632b7e3
|
Add option to skip raw SQL file when dumping postgres DB
trying to cut down on disk space, we'll see how well this works..
|
2023-09-16 16:57:10 -05:00 |
|
|
Lance Edgar
|
8e9a685006
|
Try again, to move postgres dump file to /tmp before restoring
so the postgres can cd to current workdir without error..fingers
crossed this doesn't break anything else again
|
2023-08-08 19:19:33 -05:00 |
|
|
Lance Edgar
|
bedca74ca1
|
Revert "Move sql file to temp path when restoring postgres db"
This reverts commit 94945fbc30.
apparently that breaks some nightly cloning (prod -> stage)
|
2023-08-06 19:20:53 -05:00 |
|
|
Lance Edgar
|
94945fbc30
|
Move sql file to temp path when restoring postgres db
otherwise postgres may throw an error, if it can't cd to current workdir
|
2023-08-03 10:54:33 -05:00 |
|
|
Lance Edgar
|
8c556e6176
|
Fix logic to bind postgres to all network interfaces
ugh, finally solved this
|
2023-01-07 17:22:21 -06:00 |
|
|
Lance Edgar
|
303f650a0b
|
Tweak logic for setting PostgreSQL listen_addresses
this still isn't right, but i'm calling this a savepoint at least
|
2022-07-25 19:53:12 -05:00 |
|
|
Lance Edgar
|
c413c2a1f2
|
Add postgres functions, set_listen_addresses and add_hba_entry
|
2021-06-15 14:16:46 -05:00 |
|
|
Lance Edgar
|
1fd9ad48d6
|
Add bootstrap_rattail_base() and related tweaks
the idea here is to have a "one stop shop" for base requirements,
we'll see how useful it is in practice i guess
|
2021-06-11 18:38:16 -05:00 |
|
|
Lance Edgar
|
8b8df95633
|
Add postgresql.script() for running arbitrary SQL script
|
2020-12-13 15:54:03 -06:00 |
|
|
Lance Edgar
|
47c27eaba5
|
Don't use sudo for parts of postgresql.restore_db()
since apparently that is a problem
|
2020-10-08 13:58:55 -05:00 |
|
|
Lance Edgar
|
97ed8eeff0
|
Split up the dump/restore DB logic for postgresql
so that i can swap out portions of that in order to use rsync for big DBs
|
2020-10-07 17:54:45 -05:00 |
|
|
Lance Edgar
|
88a08fcf8f
|
Try to suppress output when setting password for postgresql
|
2020-02-06 23:23:08 -06:00 |
|
|
Lance Edgar
|
56acb30008
|
Add postgresql.reload() function
|
2019-10-29 20:55:24 -05:00 |
|
|
Lance Edgar
|
325f85a4b3
|
Add postgresql.create_schema()
|
2019-10-04 23:08:39 -05:00 |
|
|
Lance Edgar
|
21bdc2b391
|
Add postgresql.get_version() function
|
2019-09-23 15:25:39 -05:00 |
|
|
Lance Edgar
|
b9c8a8d104
|
Add postgresql.restart() convenience function
|
2019-09-13 13:24:18 -05:00 |
|
|
Lance Edgar
|
bac78764d0
|
Fix how we run sudo commands as postgres user
|
2019-02-19 22:36:35 -06:00 |
|
|
Lance Edgar
|
76ab2915c8
|
Add functions for cloning postgres DB
|
2018-12-03 22:14:55 -06:00 |
|
|
Lance Edgar
|
e8769c8245
|
Initial commit; enough to prove concepts at least
was able to bootstrap a complete machine with this, although there's lots
missing yet...
|
2018-12-03 01:11:38 -06:00 |
|