|
Hello – I’m relatively new to the postgresql world –
primarily using it to load up a backup of our hosted Jive community databases
(which use postgresql). To that end, we’ve created and scheduled a batch file (yes,
we’re using a windows server…) to download the backups (*.dmp
files) from the hosted service and reload our local databases each night.
The process appears to work fine (i.e., the databases are loaded
as expected), but every day there is another lingering instance of “createdb.exe”
in the task manager. This does not appear to happen when I run the batch
file manually from the command line – only when it runs as a scheduled
task. Here’s a trimmed down version of the batch file –
it’s relatively simplistic at this point. Has anyone run into this
issue, or have any suggestions for where to start…? rem Remove previously downloaded backup files del *.dmp rem Use wget to download 2 backup files "C:\Program Files\WinWget\wget\wget.exe"
--http-user=%USER% --http-passwd=%PASS% "%ANALYTICS_DATABASE%.dmp" "C:\Program Files\WinWget\wget\wget.exe"
--http-user=%USER% --http-passwd=%PASS% "%FULL_BACKUP%.dmp" rem Restart the windows service to ensure no connected users
– otherwise dropdb will fail net stop postgresql-8.4 net start postgresql-8.4 rem Drop existing databases "c:\Program Files\PostgreSQL\8.4\bin\dropdb.exe"
-U postgres -w jive_analytics "c:\Program Files\PostgreSQL\8.4\bin\dropdb.exe"
-U postgres -w jive_full rem Recreate Analytics database "c:\Program Files\PostgreSQL\8.4\bin\createdb" -U
postgres jive_analytics "c:\Program Files\PostgreSQL\8.4\bin\pg_restore"
-U postgres -O -d jive_analytics "%ANALYTICS_DATABASE_FILE%.dmp" rem Recreate Analytics database "c:\Program Files\PostgreSQL\8.4\bin\createdb" -U
postgres jive_full "c:\Program Files\PostgreSQL\8.4\bin\pg_restore"
-U postgres -O -d jive_full "%FULL_BACKUP_FILE%.dmp" rem Grant access to all tables to jive_local user for both
databases "c:\Program Files\PostgreSQL\8.4\bin\psql.exe" -U
postgres -d jive_full -qAt -c "select 'grant select on ' || tablename || '
to jive_local;' from pg_tables where schemaname = 'public'" |
"c:\Program Files\PostgreSQL\8.4\bin\psql.exe" -U postgres -d
jive_full "c:\Program Files\PostgreSQL\8.4\bin\psql.exe" -U
postgres -d jive_analytics -qAt -c "select 'grant select on ' || tablename
|| ' to jive_local;' from pg_tables where schemaname = 'public'" |
"c:\Program Files\PostgreSQL\8.4\bin\psql.exe" -U postgres -d
jive_analytics |
