Re: Switching Primary Keys to BigInt

2020-07-26 Thread Mohamed Wael Khobalatte
On Tue, Jul 21, 2020 at 11:30 AM Mohamed Wael Khobalatte < mkhobala...@grubhub.com> wrote: > Hi all, > > We are running 9.6, and we are planning to move some primary keys from int > to bigint because we are approaching the type limit. We understand this > requires some downtime, but we want to kno

shp2pgsql is missing

2020-07-26 Thread Susan Hurst
How can I acquire or download the shp2pgsql file that I need for the tiger geocoder? All of the online searches for a solution have not been helpful. Supposedly, shp2pgsql is supposed to just be there when postgis is installed, but it's not. I even tried updating postgis with: ALTER EXTENSI

Re: shp2pgsql is missing

2020-07-26 Thread Adrian Klaver
On 7/26/20 11:25 AM, Susan Hurst wrote: How can I acquire or download the shp2pgsql file that I need for the tiger geocoder? All of the online searches for a solution have not been helpful. Supposedly, shp2pgsql is supposed to just be there when postgis is installed, but it's not.  I even tri

Re: shp2pgsql is missing

2020-07-26 Thread Christoph Moench-Tegeder
## Susan Hurst (susan.hu...@brookhurstdata.com): > OS: FreeBSD 12.1-RELEASE-p7 FreeBSD 12.1-RELEASE-p7 GENERIC amd64 There's your answer: the FreeBSD port of PostGIS 3.0 (databases/postgis30) installs shp2pgsql only if option LOADERGUI has been enabled on the port's build (the port defaults to

Re: TDE implementation in postgres which is in docker container

2020-07-26 Thread raf
On Sat, Jul 25, 2020 at 10:24:26AM -0500, Ron wrote: > On 7/24/20 11:38 AM, Vasu Madhineni wrote: > > Hi All, > > > > How to implement TDE in postgres which is running docker containers. > > Postgres does not have TDE.  You need to encrypt at the filesystem level. ecryptfs works really well wi