systemcr

Sorry, done :-)

Hi everyone,

As I explained in a former post, I'd like to schedule a cron job to run an SQL script on my PostgreSQL database for maintenance stuff.

The thing is that I am receiving this error when the cron job is being executed (see image attached).

Could anyone help me please?

Thanks in advance!

Nice, thanks a lot!

Hello,

I'd like to know if I can use 'psql' instead of 'php' to run a daily maintenance SQL script on my PostgreSQL database as a cron job from cPanel.

The command line to execute would be something similar to the following, according to https://dba.stackexchange.com/questions/157991/how-to-create-jobs-in-postgresql/157992#157992

psql -d myDb -f "maintenance.sql"

Thank you very much in advance.

Hi again,

After some research, I've seen it's been a matter of granting access for the user I use to connect to my database at a schema level. After granting it access to my newly-created schema, I can work now from pgAdmin. :-)

Hi,

I think it is more to grant access to the user I use to connect through pgAdmin to be able to use all of the objects in the database. I think I've done it from phppgadmin, but there're asterisks in the table of privileges after grating them whose meaning I don't understand: 

Screenshot: https://i.ibb.co/wsKJKJG/Screenshot-1.png

I can't still work from pgadmin after this grant.

I need to work from pgadmin because I can't be creating my database objects from a UI tool like the one provided by phppgadmin; I need to do this through SQL (I know, I can also run SQL from phppgadmin, but it's absolutely not the same working from a tool like pgAdmin).

Hi,

I will then configure two cron jobs from cPanel. Instead of using php, could I use psql to connect to the database like this Stackoverflow says? https://dba.stackexchange.com/a/157992

If so, I would like to know how and where I can place the .sql file to be given to the psql command.

Thanks!

Hi,

Thanks a lot for your response. Yes, I can create schemas from phppgadmin (I didn't know this tool did exist). However I think creating schemas from pgadmin should be possible.

Kind regards.

Yes of course. I completely understand. Just asking to know if he wasn't here anymore 

Is Krydos on vacation? Just asking to get an idea about how long this answer can be delayed, as I can't continue working if I can't create schemas on my database.

Thanks!

Hi Wolstech,

I'd prefer to be one to schedule the maintenance scheduled tasks, because if something would fail, I'd like to fix it by myself as soon as possible to minimize my customer's impact.

Can this also be escalated to Krydos? So that I can take into consideration his opinion about this issue as well.

Hi,

No problem if the version can't be updated. However, not being able to create schemas is a big limitation in my opinion, as it helps a lot to keep database's objects well organized. It'd be great if we could create them.

Hi Wolstech,

Yes, I've read about cron jobs but I was thinking in more in some alternative "self-contained" in the database. However, it seems a good approach to me what you say about using scheduled tasks on Lily or schedule cron jobs in any other server.

About scheduling tasks on Lily, has anyone done this before? So that I can search in the forum first prior asking for explanation on how to do that. 

Hello everyone,

I need to perform some daily "maintenance" tasks on my PostgreSQL database that include mainly deleting old data and backuping some tables. I've read that PostgreSQL does not include any built-in feature to schedule these kind of tasks, similar to what can be achieved on Microsoft SQL Server through the use of jobs.

However, I've read there's an extension called pg_cron [1] that can be used to achieve this in PostgreSQL. Is it possible to use it within the PostgreSQL databases we're provided on Johnny?

Thanks in advance!

[1] https://github.com/citusdata/pg_cron

Hi,

I want to create a new schema on my PostgreSQL database but it seems I don't have enough permissions to do so (image attached).

Can anyone tell me why?

Thanks in advance!

PD: by the way, it seems PostgreSQL's version on Johnny is 9.2, which is a bit old... could it be updated?

Thanks a lot guys for the info!

Hi everyone,

Regarding the PostgreSQL database we can have on Johnny, two questions:

• Which size does it actually have? I can see 1,000 MB from my cPanel but I wonder if this is the actual size it has. If so, could it be extended in the future?
• How many concurrent connections does it support?

Thanks in advance! 

Kind regards.

Hi,

Could you please grant me remote access to my PostgreSQL database?

Server: Johnny

Database name: systemcr_pretiumsuite

Username: systemcr_sa

Thanks in advance!

Hello everyone,

First of all, thanks for this amazing service that you provide for free. I truly appreciate it.

I wonder if it would be possible to deploy and run an ASP.NET Core web app on HelioHost.

I've read that, for this, HelioHost provides the server "Lily", which is for Microsoft-related technologies such as this which I've already mentioned. The thing is that I'd also need some database because my app will need one. Preferably, I'd need PostgreSQL but if this isn't possible, SQL Server is my second option.

I've already asked if I could have access to Johnny (to have a running PostgreSQL database there) and Lily (for my web app) but I've been told this isn't actually possible due to HelioHost's policy.

Apart from this, I'd like to keep this web app accessible from a custom domain, let's say: www.my-incredible-app.com. Would this be possible with HelioHost (and Lily)?

Thank you guys in advance!

Edit - PD: my project will consist of Python scripts logging information to this database the web app will use, so remote access from for example my home IP (and not only from a web app hosted in HelioHost) will be needed. Still possible? :-)

What if I want to connect from the outside?

What postgresql username do you want to have remote access to what postgresql database? As far as a connection string it depends on the language you're using. For php running on the server it would look something like

$dbconn = pg_connect("host=localhost dbname=systemcr_database user=systemcr_user password=secret123");

Hi Krydos,

Thanks for your response. Exactly, that would be a connecion string for PHP (although I am more interested in a dot-net-like connection string). However, what a I really want to know is which host I need to use (in your example you say "localhost", but I guess my host running in HelioHost should have a different name). This is what I want to find.

Thanks again!

Hello everyone,

I've created a new PostgreSQL database. However, when I access it from my cPanel, I can't see any section to get the parameters needed to establish a connection from pgAdmin (something like a connection string: hostname, database, etc).

Where can I get this information?

PD: I've read some users don't have access from remote to their PosgreSQL database as default. I'd like to know if this is true and if so, if somebody could please grant me access.

Thanks in advance.