[Answered] installing postgresql database from backup

[nltrade]

Hi folks, thanks for all your help so far.  I have a postgresql database on a local server that I would like to move to heliohost.  Can I "restore" a database (setup and data) on the heliohost server? (soon to be tommy). 

 

Best,

R Haynes

[wolstech]

You can import the structure and data into an empty database using phppgadmin, or if you request remote access, could do it using anything on your computer that can connect to postgres.

[nltrade]

You can import the structure and data into an empty database using phppgadmin, or if you request remote access, could do it using anything on your computer that can connect to postgres.

 

Thanks!  I assume I can request remote access from the control panel? 

[wolstech]

Create the database and user, then post the name of each here. Krydos has to set remote access up manually.

[nltrade]

Create the database and user, then post the name of each here. Krydos has to set remote access up manually.

 

Hi folks, the database name and user are:

 

nltrade_hockey1

nltrade_rh

 

Will post in a separate thread to ensure it is seen, feel free to delete one or the other. 

Edited February 14, 2021 by nltrade

[Luigi123]

Just to clarify with the Admins/Mods to avoid the confusion:

 

https://www.helionet.org/index/topic/42552-remote-access-requested/?do=findComment&comment=183935