Minimum privilege for Backup and replication

2019-10-10 Thread Timmy Siu
Dear All Postgresql Users, I am new to pgsql. I have an installation on my Ubuntu 18.04. Now, my question is - What is the Minimum Privilege of a pgsql Backup or Replication user? I know how to do it for mysql but not pgsql.?? I begin to switch to pgsql v11 from mysql v5.7 after knowing it many

Re: Allowing client access

2019-10-09 Thread Timmy Siu
Dear Bob, Thank you.?? hostssl works out of the box!?? It does not require extra configuration.?? I can connect to my own pgsql server via pgadmin 4.?? I personally feel that Postgresql v11 is much clever than Mysql v5.7 (I haven't tried its v8). I also have tested postgres against TCP Wrappe

Allowing client access

2019-10-09 Thread Timmy Siu
Dear All Users, * How do I allow an external client IP address access to my pgsql server? According to my own experience and test, if I set the external client IP address to, for example, 111.222.333.444 in the file /etc/postgresql/11/main/pg_hba.conf, it will not be able to connect to the s

GPS coordinates problem

2019-10-08 Thread Timmy Siu
Dear All Postgre Users, I want to develop a new project on Lavarel 5 and Postgresql 11. Now, I need Global Position System coordinates as a data type. How do I define it in Postgresql 11 or 12? Thanks for your help. Timmy