Re: Connecting to Postgresql without IP address

Your connection string will work as long as there is a DNS entry for PGServer. Your pg_hba.conf will however need to have an IP address/netmask. So if you are connecting from within your local network, you can put something like: hostssl all all 192.168.0.0/16 md5 Hth? On W

Re: pg_restore (fromuser -> touser)

arallelization options. > > > > Are there any such features on the roadmap? Is my understanding correct > about the available ways to accomplish this – again, in a practical and > performant way? > > > > Thanks, > > Mayan > -- [image: Ausvet Logo] <https://www.au

Re: help implementing OGR Postgres foreign data wrapper

;https://www.facebook.com/nzniwa> LinkedIn > <https://www.linkedin.com/company/niwa> Twitter > <https://twitter.com/niwa_nz> Instagram > <https://www.instagram.com/niwa_science> To ensure compliance with legal > requirements and to maintain cyber security standards,

Re: Postresql/postgis/qgis : assign privileges only for access/reading tables ?

ructure, I don't see the list of > tables. > Where can the error come from? Have I forgotten something? > > Thank you. > -- [image: Ausvet Logo] <https://www.ausvet.com.au/> Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICD Managing Director E-mail: b...@ausvet.com.au Website: www.ausvet.com.au Address: 5 Shuffrey Street Fremantle, WA 6160 Australia

Re: Is PostgreSQL SQL Database Command Syntax Similar to MySQL/MariaDB?

ts ;-) > > regards, tom lane > > > -- [image: Ausvet Logo] <https://www.ausvet.com.au/> Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICD Managing Director Mobile: +61 448 887 220 <+61448887220> E-mail: b...@ausvet.com.au Website: www.ausvet.com.au Skype: benmadin Address: 5 Shuffrey Street Fremantle, WA 6160 Australia

Re: Replica on low-bandwitdh network

h > trigger to commit changes to the other server), > we think for the uncommon latency. > > Which is, for you, the best replication module for Postgresql? > Bucardo? Something else? > > Thank you, very best! > F > > -- Dr Ben Madin m : +61 448 887 220 e : b...

Re: Can postgresql ignore DST ?

and vice versa. >> >> It should not have any other effects. > > > I think what I see is some dates might have changed - is that a > possibility ? > > If yes, is there any way I can revert back ? > > Regards, > Ven > > >> -- > > Regards,

Re: Using AWS ephemeral SSD storage for production database workload?

t; > Already using it for multiple deployments. I am primarily a programmer. > But now want to get out of the RDS convenience zone. > > Regards, > > Pritam. > > -- Dr Ben Madin Managing Director m : +61 448 887 220 e : b...@ausvet.com.au 5 Shuffrey Street, Fremantle

Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade

; Unit entered failed stat >> Mar 28 19:51:50 kcb-VirtualBox systemd[1]: postgresql@9.3-main.service: >> Failed with result 'exit >> >> Is it possible a big problem is that the password for user postgres not >> longer works for some reason, not sure why. It appears the pas

Re: How to create function returning numeric from string containing percent character

gt; $BODY$ language sql immutable; > > but if string contains % character, > > select val('1,2%') > > returns 0. > > How to force it to return 1.2 ? > > It should work starting from Postgres 9.0 > > Posted also in > > > https://stackoverfl

index numbers in pg_restore list

pt to grep the lines we need out of the list of the current dump, not re-use the same list file? cheers Ben -- [image: Ausvet Logo] <https://www.ausvet.com.au/> Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICD Managing Director Mobile: +61 448 887 220 <+61448887220> E-mail: b...

Re: index numbers in pg_restore list

Thanks Tom and Adrian, The clarity is helpful - We'll run up a solution to specifically choose the elements. cheers Ben On Sat, 15 Aug 2020 at 00:45, Tom Lane wrote: > Ben Madin writes: > > " Is the index number ( the archive ID) assigned at the time of creation > &g

Problem building psql on Mac OS 10.15 (around readline bit I think)

might be a readline upgrade again? cheers Ben -- [image: Ausvet Logo] <https://www.ausvet.com.au/> Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICD Managing Director Mobile: +61 448 887 220 <+61448887220> E-mail: b...@ausvet.com.au Website: www.ausvet.com.au Skype: benmadin Address: 5 Shuffrey Street Fremantle, WA 6160 Australia

Re: Problem building psql on Mac OS 10.15 (around readline bit I think)

he build script still failed at the same point showing the same error citing the readline/history.h from the apple SDK's... is there something else I have to do to ensure it uses the ones on the PATH and specified in the configure? cheers Ben On Mon, 1 Mar 2021 at 12:50, Tom Lane wrote:

Re: Ways to deal with large amount of columns;

there be anything like define a > macro in C that I can manipulate multiple columns by simple word that > representing them. > > Thanks so much! > > Shore > -- [image: Ausvet Logo] <https://www.ausvet.com.au/> Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICD

Re: Saving view turns SELECT * into field list

der advising > of the error in transmission and immediately delete/destroy the message and > any accompanying documents. Thank you. > -- [image: Ausvet Logo] <https://www.ausvet.com.au/> Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICD Managing Director Mobile: +61 448 887 220 <+61448887220> E-mail: b...@ausvet.com.au Website: www.ausvet.com.au Skype: benmadin Address: 5 Shuffrey Street Fremantle, WA 6160 Australia

Re: Problem creating a database

l - even on the highest > debug setting, I only see the "connection authorized" then the fatal "could > not open file" error. > > The data directory is on a separate disk array to the OS. Recently checked > it and there are no disk errors. > > Any thoughts or

Re: Case Insensitive

--* >> * 1 | aaa* >> * 2 | AAA* >> *(2 rows)* >> *--above result is just an manual made example only* >> >> > You can write a query with upper function: > > select * from emp where upper(ename)=upper('aaa'); > > Or you can overload the