RE: PostgresSQL 10 on remote server - Socket is not connected (0x00002749/10057)

2020-01-24 Thread Tanja Savic
Hi, Thank you for your replies. I can connect to remote server using psql and it works normally, I can do the select, function calls.. But in pgAdmin, even SELECT 1 doesn't work. Also, the weirdest thing is that it actually worked for a brief moment, because I logged using pgAdmin and created

Re: Does converting an indexed varchar to text rewrite its index? Docs say so, tests say no.

2020-01-24 Thread Laurenz Albe
On Thu, 2020-01-23 at 08:55 -0800, Mike Lissner wrote: > I think the docs say that if you convert a varchar to text, it'll rewrite the > index, > but my test doesn't seem to indicate that. Is the test or the documentation > wrong? > > If the docs, I'll be happy to make a fix my first contributio

Re: Clarification of documentation detail for upgrading minor version

2020-01-24 Thread Phil Fisher
Thanks to Adrian I have managed to get around this issue. Essentially I had to go old school and create a tar archive of the install on another comparable system, copy that around and then install via an untar. (the repo access was not available as it is a server behind many FW and in a secure vD

Re: PostgresSQL 10 on remote server - Socket is not connected (0x00002749/10057)

2020-01-24 Thread Adrian Klaver
On 1/24/20 2:31 AM, Tanja Savic wrote: Hi, Thank you for your replies. I can connect to remote server using psql and it works normally, I can do the select, function calls.. But in pgAdmin, even SELECT 1 doesn't work. Also, the weirdest thing is that it actually worked for a brief moment, be

Re: Clarification of documentation detail for upgrading minor version

2020-01-24 Thread Adrian Klaver
On 1/24/20 12:27 AM, Phil Fisher wrote: Please reply to list also. Ccing list. Hi Adrian no the version currently installed came from a RHEL repo I believe so binaries etc. are not in same place, /usr/local IIRC. If there is a an easy/simple way of describing an approach it would be good as I

Re: Clarification of documentation detail for upgrading minor version

2020-01-24 Thread Adrian Klaver
On 1/24/20 6:40 AM, Phil Fisher wrote: Thanks to Adrian I have managed to get around this issue. Essentially I had to go old school and create a tar archive of the install on another comparable system, copy that around and then install via an untar. (the repo access was not available as it is a

Time zone "GST" not recognized.

2020-01-24 Thread nikhil raj
Hi ALL, Required help with the time zone. i am getting error on the GST time line. is tht a bug or postgres doesn't support the GST time zone. select CURRENT_TIMESTAMP AT TIME ZONE 'GST' ERROR: time zone "GST" not recognized SQL state: 22023 Postgres -:11.2 Ubuntu:-18.04

Re: Time zone "GST" not recognized.

2020-01-24 Thread Tom Lane
nikhil raj writes: > Required help with the time zone. i am getting error on the GST time line. > is tht a bug or postgres doesn't support the GST time zone. There is no such time zone abbreviation according to the IANA time zone database [1], which is what we rely on. re

Re: Time zone "GST" not recognized.

2020-01-24 Thread Adrian Klaver
On 1/24/20 8:59 AM, nikhil raj wrote: Hi ALL, Required help with the time zone. i am getting error on the GST time line. is tht a bug or postgres doesn't support the GST time zone. select CURRENT_TIMESTAMP AT TIME ZONE 'GST' ERROR: time zone "GST" not recognized SQL state: 22023 Try GMT:

Re: Time zone "GST" not recognized.

2020-01-24 Thread Adrian Klaver
On 1/24/20 9:19 AM, Adrian Klaver wrote: On 1/24/20 8:59 AM, nikhil raj wrote: Hi ALL, Required help with the time zone. i am getting error on the GST time line. is tht a bug or postgres doesn't support the GST time zone. select CURRENT_TIMESTAMP AT TIME ZONE 'GST' ERROR: time zone "GST" no

continuation character for meta commands in psql

2020-01-24 Thread Matt Zagrabelny
Greetings, I've searched the internet and also the pgsql-general list for an answer to this question, but couldn't find one. Is there a continuation character for meta commands in psql? I've seen mention that a caret (^) could be used, but it didn't work correctly and the psql man page makes no

Re: continuation character for meta commands in psql

2020-01-24 Thread Adrian Klaver
On 1/24/20 9:42 AM, Matt Zagrabelny wrote: Greetings, I've searched the internet and also the pgsql-general list for an answer to this question, but couldn't find one. Is there a continuation character for meta commands in psql? I've seen mention that a caret (^) could be used, but it didn't

Re: continuation character for meta commands in psql

2020-01-24 Thread Tom Lane
Matt Zagrabelny writes: > Is there a continuation character for meta commands in psql? No. regards, tom lane

Re: Time zone "GST" not recognized.

2020-01-24 Thread nikhil raj
Hi Adrian, Thanks for the quick response. Please can you help me over here So Postgres is not supporting GST ( Gulf Standard Time) time zone . As if we have a entries of few things with timestamp with time zone from application end. example :- In 2 column we are entering these details but whe

Re: Time zone "GST" not recognized.

2020-01-24 Thread Tom Lane
nikhil raj writes: > Please can you help me over here So Postgres is not supporting GST ( Gulf > Standard Time) time zone . As if we have a entries of few things with > timestamp with time zone from application end. You could set up a private timezone abbreviation configuration. https://www.po

Re: Time zone "GST" not recognized.

2020-01-24 Thread Adrian Klaver
On 1/24/20 9:57 AM, nikhil raj wrote: Hi Adrian, Thanks for the quick response. Please can you help me over here So Postgres is not supporting GST ( Gulf Standard Time) time zone .  As if we have a entries of few things with timestamp with time zone  from application end. example :- In 2 co