Question : I have a cron job that runs a script that connects to a remote postgres database that I […]
Tag: postgresql-9.2
Postgresql Run ‘Jobs’ At Specific Times
Question : I have a normal problem to anyone that can’t trust on applications to do their ‘work/ AKA be […]
Make column default a query
Question : Is there a way I can set up a column in PostgreSQL 9.2 such that the default value […]
Slow Query with LIMIT
Question : We have this query: SELECT “messages”.* FROM “messages” WHERE “messages”.”account_id” = 1 AND “messages”.”status” = ‘unread’ AND (created_at […]
PostgreSQL “freeze”/”unfreeze” command equivalents
Question : In Derby (an embedded database written in Java which is mostly used for testing or prototyping) there are […]
How to use value return by postgresSQL function in another query
Question : I am calling PostgreSQL function that returns me the text, How can I store this value in local […]
Why aren’t my Postgres WAL segments (up to the point of turning on archiving) being archived?
Question : The pg_xlog directory for my master cluster looks like this: -rw——- 1 postgres postgres 16M Jun 21 21:42 […]
Function execute query, manipulates result and then return the same result
Question : I need a function that does something like this pseudocode: function get_data() RETURN SET OF something… as BEGIN […]
Postgresql not using GIN trigram index when performing non-ASCII LIKE query?
Question : Steps to reproduce Create database CREATE DATABASE citiesdb WITH OWNER = citiesowner ENCODING = ‘UTF8’ TABLESPACE = pg_default […]
Pgpool – 3.5 configuration
Question : [enterprisedb@pgdvdb1dr bin]$ 2017-06-20 11:34:41: pid 103313: WARNING: could not open configuration file: “pgpool.conf” 2017-06-20 11:34:41: pid 103313: DETAIL: […]