webgisdr restore fails on Portal

Question

Hi,

I am trying to do webgis restore on parallel 10.8.1 arcgis in Windows environment .

Planning to upgrade to 11.1 later from this.

I have modified /etc/hosts as recommended in esri blog.

https://www.esri.com/arcgis-blog/products/arcgis-enterprise/administration/migrate-to-a-new-machine-in-arcgis-enterprise-two/#:~:text=Steps%20to-,migrate,-distributed%20environments

Server and DataStore restore have succeded as per command line output.

But the Portal restore fails with message "Database is not running on port 7654. Please start the server before invoking this call'

I checked all the services and datastore, database are all up and running.

1) Can we only import the portal data from webgisdr backup in these types of circumstances ?

2) How do i fix the database error?

3) Any easy methods to copy the portal items to the new portal on the parallel server? or any scripts?

4) How can I change the URL of portal items to test URLs so that i can allow UAT testers to access the system.

Thanks

webgisdrfail.png

FilterWidget2.PNG

coolgis · Answer

Hi @JakeSkinner

I deleted the postmaster.pid file first time i ran.

Second time It complains about "could not create any tcp/ip sockets" .

I checked netstat -aon command and 7654 post is inListening and Established states. postgres.exe is using this port.

Thanks

pg_ctl output.png

JakeSkinner · Answer

Hi @coolgis,

Try manually starting the database with the following steps:

1.  On the portal server, open a command prompt as an Admin

2.  Navigate to the pgsql\bin directory within the Portal install location, ex:

cd C:\Program Files\ArcGIS\Portal\framework\runtime\pgsql\bin

3.  Execute the below command replace C:\arcgisportal\db with the path to your db folder:

pg_ctl -m fast start -o "-p 7654" -D C:\arcgisportal\db