[Solved] Postgres TimeZone and Crypting functions

[jolivac256]

Hi there, if possible, I would like to change the postgres DB (jolivac256_mrwallace) Timezone and add an extension to allow crypting functions. I hope the following commands are enough:

SET TIME ZONE 'America/Mexico_City';
CREATE EXTENSION IF NOT EXISTS pgcrypto;

thank you in advance.

[wolstech]

I'm not sure if the timezone can be set per database in PG or not...

The extension will need to be created by Krydos if it's supported.

[jolivac256]

Ok, I hope so. Anyway, thank You Wolstech.

[Krydos]

The pgcrypto externsion has been created. For the timezone the proper way to handle it is in your software. For instance if you're using PHP you could use

date_default_timezone_set('America/Mexico_City');

Another alternative is you could get a VPS and set the time zone however you want.

[jolivac256]

Hi Krydos, You're right, there are some options to manage timezones, and the vps alternative. Thank you!