Just use 0.0.0.0/0. host all all 0.0.0.0/0 md5 Make sure the listen_addresses in postgresql.conf (or ALTER SYSTEM SET) allows incoming connections on all available IP interfaces. listen_addresses=”*” After the changes you have to reload the configuration. One way to do this is execute this SELECT as a superuser. SELECT pg_reload_conf(); Note: to change listen_addresses, a … Read more
Extract the table and pipe it directly to the target database: pg_dump -t table_to_copy source_db | psql target_db Note: If the other database already has the table set up, you should use the -a flag to import data only, else you may see weird errors like “Out of memory”: pg_dump -a -t table_to_copy source_db | … Read more
Postgres allows the use of any existing database on the server as a template when creating a new database. I’m not sure whether pgAdmin gives you the option on the create database dialog but you should be able to execute the following in a query window if it doesn’t: CREATE DATABASE newdb WITH TEMPLATE originaldb … Read more
The driver name is OK. It is the same as mentioned in the official docs of the driver. Therefore the driver is just not in the classpath. You say: I […] properly set the application ClassPath On the other hand you start the program by just calling: java JavaPostGreSQLConnectivity In that case no PG driver … Read more
Thanks to function type resolution we can also pass date values to generate_series() because there is an implicit cast from date to timestamp as well as from date to timestamptz. Would be ambiguous, but timestamptz is “preferred” among “Date/time types”. Detailed explanation: Generating time series between two dates in PostgreSQL For a bare date the … Read more
Isn’t it just doing what is supposed to be done? Which is to compensate the distortion due to projecting the ellipsoid into a 2D flat structure? I believe, the further away you get from the equator, the more oval buffers you will see. Examples: db=# SELECT ST_AsText( ST_Buffer( ST_GeomFromText(‘SRID=4326;POINT(43.29 5.41)’),0.001, ‘quad_segs=16’) ); This query returns … Read more
Erwin sent a correct reply. My next reply is related to possibility to disable overloading. It is not possible to disable overloading – this is a base feature of PostgreSQL function API system – and cannot be disabled. We know so there are some side effects like strong function signature rigidity – but it is … Read more
As shown in the latest edit, the password is valid until 1970, which means it’s currently invalid. This explains the error message which is the same as if the password was incorrect. Reset the validity with: ALTER USER postgres VALID UNTIL ‘infinity’; In a recent question, another user had the same problem with user accounts … Read more
serial is the “old” implementation of auto-generated unique values that has been part of Postgres for ages. However that is not part of the SQL standard. To be more compliant with the SQL standard, Postgres 10 introduced the syntax using generated as identity. The underlying implementation is still based on a sequence, the definition now … Read more
This has come up a few times recently, both on SO and on the PostgreSQL mailing lists. The TL;DR for your last two points: (a) The bigger shared_buffers may be why TRUNCATE is slower on the CI server. Different fsync configuration or the use of rotational media instead of SSDs could also be at fault. … Read more