webgisdr restore fails on Portal

[coolgis]

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-...

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

[JakeSkinner]

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

[coolgis]

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