Upgrade from 4650 to 5000 killed postgres
The upgrade itself worked fine, but when I attempted to restart the server it exited. This is in the logs:
[08:56:25:693]|[07-12-2017]|[StartLog]|[INFO]|[20]: The 'product.home' system property. ..|
[08:56:25:693]|[07-12-2017]|[StartLog]|[INFO]|[20]: processInfoFileName ..\conf/TrayIconInfo.xml|
[08:56:25:693]|[07-12-2017]|[StartLog]|[INFO]|[20]: processInfoFileName file exists |
[08:56:25:990]|[07-12-2017]|[StartLog]|[INFO]|[20]: trayIconProps {DefaultMenuItem=StartClient, ApplicationName=ADAP, Menu=[{Id=Status, DisplayName=ADAudit Plus Status, RunProcess=ShowADAPStatus}, {Id=StartClient, DisplayName=Start ADAudit Plus Client, RunProcess=StartADAPClient}, {Id=ShutDownServer, DisplayName=Stop ADAudit Plus, RunProcess=ShutdownADAP}], EnableIcon=../images/systray_enabled.png, DisableIcon=../images/systray_disabled.png, ToolTipText=ManageEngine ADAudit Plus, MainProcess=StartADAP, DefaultRunProcess=ShowADAPStatus}|
[08:56:26:053]|[07-12-2017]|[StartLog]|[INFO]|[20]: application_name ADAP|
[08:56:26:053]|[07-12-2017]|[StartLog]|[INFO]|[20]: processName: StartADAP|
[08:56:26:053]|[07-12-2017]|[StartLog]|[INFO]|[20]: Starts checking Memory Configurations|
[08:56:26:100]|[07-12-2017]|[StartLog]|[INFO]|[20]: productHome: ..|
[08:56:26:100]|[07-12-2017]|[StartLog]|[INFO]|[20]: processFileStr1: ..\logs\memOut.txt|
[08:56:26:100]|[07-12-2017]|[StartLog]|[INFO]|[20]: Out of Memory Exception Not occurs|
[08:56:26:100]|[07-12-2017]|[StartLog]|[INFO]|[20]: Finished checking Memory Configurations|
[08:56:26:100]|[07-12-2017]|[StartLog]|[INFO]|[20]: commands: [{Name=StartADAP, AdditionalParams={WebServerPortFileName=../conf/server.xml, client_startup_settings_filename=../conf/client_params.conf, SplashImageFileName=../images/splash.png, ForegroundColor=107-210-73, BackgroundColor=255-255-255, StartupMsgsFileName=../conf/startupmsgs.txt}, Type=InvokeClass, EnvironmentVariables=[], OriginalCommand=com.adventnet.sym.adsm.start.StartADSM}, {Name=StartADAPWebClient, AdditionalParams={WebServerPortFileName=../conf/server.xml, client_startup_settings_filename=../conf/client_params.conf, command=rundll32 url.dll,FileProtocolHandler http://localhost:}, Type=InvokeClass, EnvironmentVariables=[], OriginalCommand=com.adventnet.sym.adsm.start.StartWebClient}, {Name=startTrayIcon, AdditionalParams={WebServerPortFileName=/conf/server.xml, processInfoFileName=conf/TrayIconInfo.xml, trayInfoFileName=conf/TrayIconInfo.xml}, Type=InvokeClass, EnvironmentVariables=[], OriginalCommand=com.manageengine.ads.startup.trayicon.TrayIconManager}]|
[08:56:26:100]|[07-12-2017]|[StartLog]|[INFO]|[20]: CHECKING FOR OUTPUT PROCESSOR, PROCESS IS null COMMAND IS :::com.adventnet.sym.adsm.start.StartADSM|
[08:56:26:271]|[07-12-2017]|[StartLog]|[INFO]|[20]: ===================================================|
[08:56:26:271]|[07-12-2017]|[StartLog]|[INFO]|[20]: ===================================================|
[08:56:26:271]|[07-12-2017]|[StartLog]|[INFO]|[20]: ===================================================|
[08:56:26:271]|[07-12-2017]|[StartLog]|[INFO]|[20]: Starting the ManageEngine ADAudit Plus Server...|
[08:56:26:271]|[07-12-2017]|[StartLog]|[INFO]|[20]: ===================================================|
[08:56:26:271]|[07-12-2017]|[StartLog]|[INFO]|[20]: ===================================================|
[08:56:26:318]|[07-12-2017]|[StartLog]|[INFO]|[21]: Invoking the main class: com.adventnet.mfw.Starter.main(): : |
[08:56:26:381]|[07-12-2017]|[com.adventnet.mfw.logging.LoggerUtil]|[INFO]|[21]: Reinitializing logging.properties|
[08:56:26:381]|[07-12-2017]|[com.adventnet.mfw.logging.LoggerUtil]|[INFO]|[21]: ..\conf\dynamic-logging.properties|
[08:56:26:381]|[07-12-2017]|[com.adventnet.mfw.logging.LoggerUtil]|[INFO]|[21]: dynamic-logging.properties not exist hence reinitialize logger properties ignored|
[08:56:26:459]|[07-12-2017]|[com.adventnet.mfw.PatchUpdater]|[WARNING]|[21]: The 'fixes' directory is missing. Product loads the jar(s) without PATCH|
[08:56:26:553]|[07-12-2017]|[com.adventnet.mfw.Server]|[INFO]|[21]: Creating new Server instance|
[08:56:26:646]|[07-12-2017]|[StartLog]|[INFO]|[20]: The webPort is :::80|
[08:56:26:646]|[07-12-2017]|[StartLog]|[INFO]|[20]: The urlStr is ::: http://localhost:80|
[08:56:26:787]|[07-12-2017]|[com.zoho.net.handshake.HandShakeServer]|[INFO]|[27]: Starting HandShakeServer...|
[08:56:26:787]|[07-12-2017]|[com.zoho.net.handshake.HandShakeServer]|[INFO]|[27]: Writing HandShakeServer port [49221] in .lock file|
[08:56:26:787]|[07-12-2017]|[com.zoho.net.handshake.HandShakeServer]|[INFO]|[27]: HandShakeServer listening port :: 49221|
[08:56:26:787]|[07-12-2017]|[com.zoho.net.handshake.HandShakeServer]|[INFO]|[27]: Waiting for client connection...|
[08:56:26:896]|[07-12-2017]|[com.zoho.net.handshake.HandShakeUtil]|[INFO]|[21]: Started HandShakeServer successfully.|
[08:56:27:896]|[07-12-2017]|[com.zoho.framework.utils.crypto.EnDecrypt]|[SEVERE]|[21]: Encryption failed|
[08:56:27:896]|[07-12-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[21]: Reading ..\conf\database_params.conf |
[08:56:27:928]|[07-12-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[21]: Reading ..\conf\database_params.conf |
[08:56:27:975]|[07-12-2017]|[com.zoho.cp.ConnectionCreator]|[INFO]|[21]: Socket Factory className--null|
[08:56:28:006]|[07-12-2017]|[com.adventnet.ds.DefaultDataSourcePlugIn]|[INFO]|[21]: DataSourcecom.zoho.cp.TxDataSource@1c5aac3|
[08:56:28:006]|[07-12-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[21]: Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter|
[08:56:28:006]|[07-12-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[21]: Storage Adapter class ::: null|
[08:56:28:021]|[07-12-2017]|[com.adventnet.db.api.RelationalAPI]|[SEVERE]|[21]: haltjvm.on.dbcrash is set to [true]|
[08:56:28:021]|[07-12-2017]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[21]: shutDownStrings :: []|
[08:56:28:037]|[07-12-2017]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[21]: isDBMigration running :: false|
[08:56:28:037]|[07-12-2017]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[21]: isDBMigration dest DB :: false|
[08:56:28:037]|[07-12-2017]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[WARNING]|[21]: Identifier [pgsql_identifiers.txt] file not exist for this database|
[08:56:28:037]|[07-12-2017]|[com.adventnet.db.adapter.postgres.PostgresSQLGenerator]|[INFO]|[21]: Encryption algorithm used :: [aes256]|
[08:56:28:037]|[07-12-2017]|[com.adventnet.db.adapter.postgres.PostgresSQLGenerator]|[INFO]|[21]: Encryption s2k-mode used :: [1]|
[08:56:28:037]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: db.home ::: ../pgsql|
[08:56:28:037]|[07-12-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[21]: DataSourcePlugIn is initialized successfully|
[08:56:28:037]|[07-12-2017]|[com.adventnet.db.adapter.AbstractRestoreHandler]|[INFO]|[21]: Restore process fully completed.|
[08:56:28:037]|[07-12-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[21]: Template replaced url :: jdbc:postgresql://localhost:33307/adap|
[08:56:28:037]|[07-12-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[21]: Reading ..\conf\database_params.conf |
[08:56:28:053]|[07-12-2017]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[INFO]|[21]: port not specified in ../pgsql\data\postgresql.conf returning default port 5432|
[08:56:28:068]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: D:\ADAUDIT\ADAudit Plus\bin\..\pgsql\bin\pg_isready.exe isExists :: true|
[08:56:28:068]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: Command to be executed [D:\ADAUDIT\ADAudit Plus\bin\..\pgsql\bin\pg_isready.exe, --host, localhost, --port, 33307, -t, 120, --username, postgres] |
[08:56:28:365]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: pg_isready returning status :: -1073741515|
[08:56:28:365]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: Checking for IPV6 support|
[08:56:28:365]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: Resolved address of host [localhost] is [localhost/127.0.0.1]|
[08:56:28:365]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: Going to start DB server using pg_ctl utility.|
[08:56:28:365]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: Command to be executed [D:\ADAUDIT\ADAudit Plus\pgsql\bin\pg_ctl.exe, -w, -D, D:\ADAUDIT\ADAudit Plus\pgsql\data, -o, "-p33307", start] |
[08:56:29:756]|[07-12-2017]|[SYSOUT]|[INFO]|[26]: Exception while checking server status.Connection refused: connect|
[08:56:31:459]|[07-12-2017]|[pglog]|[INFO]|[33]: waiting for server to start.... done|
[08:56:31:459]|[07-12-2017]|[pglog]|[INFO]|[33]: server started|
[08:56:31:475]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: waitfor pgctl Utility returns :: 0|
[08:56:31:475]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: is DB registered as a service ::: false|
[08:56:31:475]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: Command to be executed [D:\ADAUDIT\ADAudit Plus\bin\..\pgsql\bin\pg_isready.exe, --host, localhost, --port, 33307, -t, 120, --username, postgres] |
[08:56:31:521]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: pg_isready returning status :: -1073741515|
[08:56:31:521]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: isServerRunning :: false|
[08:56:31:521]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[21]: isServerStarted :: going to return :: false|
[08:56:31:521]|[07-12-2017]|[com.adventnet.persistence.PersistenceInitializer]|[SEVERE]|[21]: Trying to start PostgresSQL server failed |
java.net.ConnectException: Trying to start PostgresSQL server failed
at com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer.startDBServer(DefaultPostgresDBInitializer.java:140)
at com.adventnet.db.adapter.postgres.PostgresDBAdapter.startAndCheckDBServer(PostgresDBAdapter.java:582)
at com.adventnet.db.adapter.postgres.PostgresDBAdapter.setUpDB(PostgresDBAdapter.java:566)
at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:978)
at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:944)
at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:567)
at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:360)
at com.adventnet.mfw.Server.startServer(Server.java:171)
at com.adventnet.mfw.Starter.start(Starter.java:363)
at com.adventnet.mfw.Starter.main(Starter.java:573)
at com.adventnet.sym.adsm.start.StartADSM$2.run(StartADSM.java:260)
[08:56:31:521]|[07-12-2017]|[com.adventnet.persistence.PersistenceInitializer]|[SEVERE]|[21]: Problem while starting Database due to:Trying to start PostgresSQL server failed |
[08:56:31:521]|[07-12-2017]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[21]: Error Code : 10001|
[08:56:31:521]|[07-12-2017]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[21]: Localized Error Msg : null|
[08:56:31:521]|[07-12-2017]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[21]: Error Msg : Exception while initializing DB.|
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: java.lang.Exception: Exception while initializing DB.|
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:364)|
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: at com.adventnet.mfw.Server.startServer(Server.java:171)|
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: at com.adventnet.mfw.Starter.start(Starter.java:363)|
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: at com.adventnet.mfw.Starter.main(Starter.java:573)|
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: at com.adventnet.sym.adsm.start.StartADSM$2.run(StartADSM.java:260)|
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: Caused by: java.lang.RuntimeException: Trying to start PostgresSQL server failed |
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: at com.adventnet.persistence.PersistenceInitializer.printErrorMsgAndHalt(PersistenceInitializer.java:1171)|
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:1063)|
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:944)|
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:567)|
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:360)|
[08:56:31:521]|[07-12-2017]|[SYSERR]|[INFO]|[21]: ... 4 more|
[08:56:31:521]|[07-12-2017]|[com.adventnet.mfw.Server]|[SEVERE]|[21]: STACK TRACE|
com.adventnet.mfw.ServerFailureException
at com.adventnet.mfw.Server.startServer(Server.java:179)
at com.adventnet.mfw.Starter.start(Starter.java:363)
at com.adventnet.mfw.Starter.main(Starter.java:573)
at com.adventnet.sym.adsm.start.StartADSM$2.run(StartADSM.java:260)
Caused by: java.lang.Exception: Exception while initializing DB.
at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:364)
at com.adventnet.mfw.Server.startServer(Server.java:171)
... 3 more
Caused by: java.lang.RuntimeException: Trying to start PostgresSQL server failed
at com.adventnet.persistence.PersistenceInitializer.printErrorMsgAndHalt(PersistenceInitializer.java:1171)
at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:1063)
at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:944)
at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:567)
at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:360)
... 4 more
This is on a windows server
and I can see instances of postgres running in the process list after this failure. If I try a manual database start using startDB.bat, I get the following log:
[11:22:07:722]|[07-12-2017]|[com.adventnet.mfw.PatchUpdater]|[WARNING]|[1]: The 'fixes' directory is missing. Product loads the jar(s) without PATCH|
[11:22:07:863]|[07-12-2017]|[com.adventnet.mfw.Starter]|[INFO]|[1]: LoadJARs already called. JARs have been loaded in previous server initialization|
[11:22:08:191]|[07-12-2017]|[com.adventnet.mfw.Server]|[INFO]|[1]: Creating new Server instance|
[11:22:08:206]|[07-12-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[1]: Reading D:\ADAUDIT\ADAudit Plus\bin\\..\conf\database_params.conf |
[11:22:11:516]|[07-12-2017]|[com.zoho.framework.utils.crypto.EnDecrypt]|[SEVERE]|[1]: Encryption failed|
[11:22:11:563]|[07-12-2017]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[1]: isDBMigration running :: false|
[11:22:11:563]|[07-12-2017]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[1]: isDBMigration dest DB :: false|
[11:22:11:578]|[07-12-2017]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[SEVERE]|[1]: Exception occured while initializing datasource.|
[11:22:11:578]|[07-12-2017]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[WARNING]|[1]: Identifier [pgsql_identifiers.txt] file not exist for this database|
[11:22:11:578]|[07-12-2017]|[com.adventnet.db.adapter.postgres.PostgresSQLGenerator]|[INFO]|[1]: Encryption algorithm used :: [aes256]|
[11:22:11:578]|[07-12-2017]|[com.adventnet.db.adapter.postgres.PostgresSQLGenerator]|[INFO]|[1]: Encryption s2k-mode used :: [1]|
[11:22:11:578]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: db.home ::: D:\ADAUDIT\ADAudit Plus\bin\\..\pgsql|
[11:22:11:578]|[07-12-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[1]: Reading D:\ADAUDIT\ADAudit Plus\bin\\..\conf\database_params.conf |
[11:22:11:594]|[07-12-2017]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[INFO]|[1]: port not specified in D:\ADAUDIT\ADAudit Plus\bin\\..\pgsql\data\postgresql.conf returning default port 5432|
[11:22:11:594]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: D:\ADAUDIT\ADAudit Plus\bin\..\pgsql\bin\pg_isready.exe isExists :: true|
[11:22:11:594]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: Command to be executed [D:\ADAUDIT\ADAudit Plus\bin\..\pgsql\bin\pg_isready.exe, --host, localhost, --port, 33307, -t, 120, --username, postgres] |
[11:22:11:656]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: pg_isready returning status :: -1073741515|
[11:22:11:656]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: Checking for IPV6 support|
[11:22:11:656]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: Resolved address of host [localhost] is [localhost/127.0.0.1]|
[11:22:11:656]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: Going to start DB server using pg_ctl utility.|
[11:22:11:656]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: Command to be executed [D:\ADAUDIT\ADAudit Plus\pgsql\bin\pg_ctl.exe, -w, -D, D:\ADAUDIT\ADAudit Plus\pgsql\data, -o, "-p33307", start] |
[11:22:12:796]|[07-12-2017]|[pglog]|[INFO]|[12]: waiting for server to start....2017-07-12 11:22:12 EDT: : @: [3464]:LOG: database system was interrupted; last known up at 2017-07-12 11:17:07 EDT|
[11:22:12:812]|[07-12-2017]|[pglog]|[INFO]|[12]: 2017-07-12 11:22:12 EDT: : @: [3464]:LOG: database system was not properly shut down; automatic recovery in progress|
[11:22:12:827]|[07-12-2017]|[pglog]|[INFO]|[12]: 2017-07-12 11:22:12 EDT: : @: [3464]:LOG: record with zero length at FA/96E33930|
[11:22:12:827]|[07-12-2017]|[pglog]|[INFO]|[12]: 2017-07-12 11:22:12 EDT: : @: [3464]:LOG: redo is not required|
[11:22:12:874]|[07-12-2017]|[pglog]|[INFO]|[12]: 2017-07-12 11:22:12 EDT: : @: [724]:LOG: database system is ready to accept connections|
[11:22:12:952]|[07-12-2017]|[pglog]|[INFO]|[12]: 2017-07-12 11:22:12 EDT: : @: [2308]:LOG: autovacuum launcher started|
[11:22:13:530]|[07-12-2017]|[pglog]|[INFO]|[12]: 2017-07-12 11:22:13 EDT: ::1(49266): my_logon_name@postgres: [3524]:FATAL: role "my_logon_name" does not exist|
[11:22:13:530]|[07-12-2017]|[pglog]|[INFO]|[12]: done|
[11:22:13:530]|[07-12-2017]|[pglog]|[INFO]|[12]: server started|
[11:22:13:530]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: waitfor pgctl Utility returns :: 0|
[11:22:13:530]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: is DB registered as a service ::: false|
[11:22:13:530]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: Command to be executed [D:\ADAUDIT\ADAudit Plus\bin\..\pgsql\bin\pg_isready.exe, --host, localhost, --port, 33307, -t, 120, --username, postgres] |
[11:22:13:530]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: pg_isready returning status :: -1073741515|
[11:22:13:530]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: isServerRunning :: false|
[11:22:13:530]|[07-12-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: isServerStarted :: going to return :: false|
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: java.net.ConnectException: Trying to start PostgresSQL server failed |
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer.startDBServer(DefaultPostgresDBInitializer.java:140)|
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.postgres.PostgresDBAdapter.startAndCheckDBServer(PostgresDBAdapter.java:582)|
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.postgres.PostgresDBAdapter.setUpDB(PostgresDBAdapter.java:566)|
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: at com.adventnet.mfw.Server.startDB(Server.java:1269)|
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: at com.adventnet.mfw.StartDB.startDBServer(StartDB.java:38)|
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: at com.adventnet.mfw.StartDB.main(StartDB.java:27)|
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: Exception in thread "main" |
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: java.net.ConnectException: Trying to start PostgresSQL server failed |
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer.startDBServer(DefaultPostgresDBInitializer.java:140)|
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.postgres.PostgresDBAdapter.startAndCheckDBServer(PostgresDBAdapter.java:582)|
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.postgres.PostgresDBAdapter.setUpDB(PostgresDBAdapter.java:566)|
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: at com.adventnet.mfw.Server.startDB(Server.java:1269)|
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: at com.adventnet.mfw.StartDB.startDBServer(StartDB.java:38)|
[11:22:13:545]|[07-12-2017]|[SYSERR]|[INFO]|[1]: at com.adventnet.mfw.StartDB.main(StartDB.java:27)|
[11:23:00:020]|[07-12-2017]|[pglog]|[INFO]|[12]: 2017-07-12 11:23:00 EDT: : @: [2308]:ERROR: canceling statement due to user request|
[11:23:00:020]|[07-12-2017]|[pglog]|[INFO]|[12]: 2017-07-12 11:23:00 EDT: : @: [724]:LOG: received fast shutdown request|
[11:23:00:020]|[07-12-2017]|[pglog]|[INFO]|[12]: 2017-07-12 11:23:00 EDT: : @: [724]:LOG: aborting any active transactions|
Before I press CTRL-C to exit the batch file, I can see that postgres is running, I assume the highlighted error is preventing something from working.
Any suggestions on how to troubleshoot this and get postgresql to start up cleanly?