Page 1 of 1

Changing PostgreSQL for pt4 on mac having emigrated.

PostPosted: Wed Aug 23, 2017 3:23 pm
by jamtheriver
Hi.

PT4 requests I change certain settings to allow me access now that i've moved to Canada. Below are the commands as advised by PT, but i'm stuck at the timezone bit.

Run the Terminal application found at /Applications/Utilities/Terminal.
Type sudo nano /Library/PostgreSQL/9.3/data/postgresql.conf
Type in your OS X administrator password if requested. This will start the Nano text editor inside of the Terminal window.
You can search for the timezone = 'X' entry by pressing CTRL+W (as indicated at the bottom of the Terminal window) and typing "timezone =".
Note that you need to change the "timezone = ..." line, which is not necessarily the first instance of timezone in the file so you may need to search more than once.
Press CTRL+O to save the file (press 'Enter' to confirm), then CTRL+X to exit the editor.
The PostgreSQL server must now be restarted to allow the changes made to the configuration file to take effect. The easiest way to accomplish this is by restarting your computer.

I've tried every combination of timezone+ I can think of, but it's responding as 'timezone not found'.

Can anyone help me?

Thanks in advance.

Re: Changing PostgreSQL for pt4 on mac having emigrated.

PostPosted: Wed Aug 23, 2017 5:50 pm
by Flag_Hippo
Can you give a specific example or two of what you have tried for the timezone entry e.g:

Code: Select all
timezone = 'Europe/London'

Re: Changing PostgreSQL for pt4 on mac having emigrated.

PostPosted: Fri Aug 25, 2017 10:35 am
by jamtheriver
Eastern Time Zone
EST
Canada
eastern time zone

I'm truly stuck here. Can I get the exact string i'm meant to input into terminal so I can paste it? I'm in Toronto, so it i'm on ETZ.

Thanks in advance.

Re: Changing PostgreSQL for pt4 on mac having emigrated.

PostPosted: Fri Aug 25, 2017 3:25 pm
by Flag_Hippo
As per our guide you need to specify your timezone with an authorized time zone property from the 'TZ' column here so for Toronto you can use this:

Code: Select all
timezone = 'America/Toronto'

or this:

Code: Select all
timezone = 'Canada/Eastern'

Re: Changing PostgreSQL for pt4 on mac having emigrated.

PostPosted: Fri Aug 25, 2017 5:38 pm
by jamtheriver
I copied and pasted exactly what you suggested into the terminal search bar, and both came back as 'not found'. Am I being retarded here, or is this more difficult than it should be?

Re: Changing PostgreSQL for pt4 on mac having emigrated.

PostPosted: Sat Aug 26, 2017 4:11 am
by WhiteRider
If you attach your postgresql.conf file to a Support Ticket we'll take a look at it for you.

highfalutin