[HH#16386] Postgresql question

[HelioHost]

Username: daskunk, Server: Ricky, Main domain: daskunk.heliohost.org

 

Good afternoon, I have a rather simple question about the heliohost site.

I'm running a simple web site on Ricky using a combination of html, cgi

perl and php scripts. So far so good. Now I'd like to add an application

that queries information from a Postgresql database. So I'd like to create

and populate a database. I noticed in your FAQ there is no interactive

shell I can log into. I found the Cpanel utility to create the database but

what's the best way to create the underlying tables, populate and manage

the database so I can get it ready for server applications?

 

Thank you very much

Gary

[Krydos]

Create the database and user through cpanel. Then you can manage it with the phppgadmin button on your cpanel. If you really like the command line you could request remote postgresql access.

[HelioHost]

Heliohost Support Staff

Again thank you so much for being so helpful. I didn't realize what

phppgadmin is and that it has such a rich suite of functions including an

import feature. Now that I've created a database and played around with

phppgadmin, I'm well on my way.

Thank you again

 

On Fri, Mar 2, 2018 at 5:32 PM, Heliohost Support

wrote:

 

> Create the database through cpanel. Then you can manage it with the

> phppgadmin button on your cpanel. If you really like the command line you

> could request remote postgresql access.

>

> You may view the status of your ticket by visiting:

>

> https://www.helionet.org/index/index.php?showtopic2020

>

> Thank you,

> Heliohost support

> https://www.heliohost.org/

> https://www.helionet.org/

>

>

[Krydos]

Yeah, phpmyadmin and phppgadmin both look like really nice software, but I've never used either. I prefer to just write my sql queries on the command line.