Data dodania Pytanie
2017-06-14 15:06 postgres functions / extensions not dumped or restored correctly? »
Update Self-answered, see first comment here and my own answer. Original question I'm setting up a local development postgres db with some sql file...
(2) odpowiedzi
2017-06-14 14:06 Postgresql 9.4 - Invalid input syntax when converting to JSONB »
I've made a simple function to update a jsonb with new values: CREATE OR REPLACE FUNCTION jsonupdate( IN "pJson" jsonb, IN "pNewValues" jsonb) ...
(1) odpowiedzi
2017-06-13 20:06 problems with stackdriver monioring postgresql on a GCE »
I installed Stackdriver on a Google Compute Engine (ubuntu) and tried to configure it to monitor the postgresql service installed in that instance. T...
(1) odpowiedzi
2017-06-13 17:06 Changing postgresql start menu location »
As part of an installer that I'm working on, I need to change the default start menu location for the postgresql installation. We're packaging a postg...
(0) odpowiedzi
2017-06-13 11:06 Shell script to monitor postgresql database status and alerts »
I need postgresql shell script to alert me if database is goes down. ...
(1) odpowiedzi
2017-06-12 16:06 PostgreSQL: SELECT * from table WHERE timestamp IS WITHIN THIS MONTH »
For some reason I'm kind of lost on how to archive: SELECT * FROM table WHERE timestamp IS WITHIN THIS MONTH; I've looked at https://www.postgresql...
(2) odpowiedzi
2017-06-12 09:06 postgresql table data movement »
In PostgreSQL i want to create script which can delete old data of before 1 month from A table(which contain many rows) and insert this data into one ...
(2) odpowiedzi
2017-06-12 05:06 Postgresql user defined c function issues »
I have installed postgresql in my ubuntu 14.04 with apt-get command.. postgresql 9.4 libpg 9.4.8 I want to add a user defined c function for dynamic l...
(1) odpowiedzi
2017-06-09 14:06 How to query NOT EXISTS on the same table? »
How to query NOT EXISTS on the same table? I need to create the select to be able to perform the insert with the results. The idea is to only insert ...
(0) odpowiedzi
2017-06-07 19:06 Map column value to table name and join »
I have a composite type that looks like CREATE TYPE member AS ( id BIGINT, type CHAR(1) ); I have a table that relies on this member type w...
(1) odpowiedzi
2017-06-07 14:06 How to get a preview for an image using postgresql? »
I'm using image tables in my database. I want to create a preview for the fetched image using PostgreSQL query. What is the syntax for creating a pre...
(0) odpowiedzi
2017-06-07 11:06 Integration of Jasper Reports with odoo 9 on Google cloud platform »
I have deployed odoo 9 Community version on Google Cloud Platform now i want to integrate Jasper Reports with odoo for BI Reporting i am trying from m...
(0) odpowiedzi
2017-06-06 20:06 EFM - There is already a master node in this cluster »
I am unable to bring up the EFM cluster that I have (managing my postgres DB). 172.29.225.67 Witness 172.29.225.81 Master 172.29.225.82 StandBy I a...
(0) odpowiedzi
2017-06-06 17:06 EFM - FATAL: password authentication failed for user "efm" »
I am currently using EFM to monitor my Postgres cluster. My EFM (Master/StandBy/Wintess) nodes were working perfectly fine until we did a VM migratio...
(0) odpowiedzi
2017-06-01 19:06 postgres is running, but I am not able to uninstall it »
So I originally downloaded PostgreSQL 9.4.10-1. The problem is I am trying to use Vagrant and Virtual Box, however Vagrant defaults to using port 5432...
(0) odpowiedzi
2017-05-31 17:05 Postgres resource usage stats and configs »
I'm using postgres server 9.4. From pg_admin or psql tool, I can do SHOW ALL; this will give me the config of postgres server. For example shared_bu...
(1) odpowiedzi
2017-05-29 20:05 real-time sync between local Postgres instance and Azure Cloud Postgres instance »
I need to set up real time sync process between a on premise postgresql instance with cloud postgresql instance. Please let me know what are all the o...
(1) odpowiedzi
2017-05-29 10:05 How can I reconnect a new PGRS server to an old local database? »
I had to upgrade my OS hard drive and lost my OSX installation and applications. I've recovered almost completely but the very large installation of c...
(0) odpowiedzi
2017-05-25 05:05 How to install oracle_fdw extension in postgresql 9.4 »
I'm trying to installing oracle_fdw packages in postgres 9.4. But it is throwing the exception below. Error: /home/ramesh/Downloads/oracle_fdw-1.2.0...
(0) odpowiedzi
2017-05-24 17:05 Postgres select where in json array containing json »
I have a table in a postgresql 9.4 database with a jsonb field. Some example rows: [{"name": "145119603", "numberOfCarrot": 2}] [{"name": "188459553...
(1) odpowiedzi
2017-05-24 16:05 How to get sub query columns in main query with WHERE EXISTS in PostgreSQL? »
I am stuck with a query which takes more time in JOIN, I want to use WHERE EXISTS in place of JOIN since as performance wise EXISTS takes less time th...
(0) odpowiedzi
2017-05-23 19:05 Casting in Postgres `where` not working as expected when using `!=` »
I have two columns in Postgres that I need to compare in a where. The column datatypes, however, are different. One is text and the other int. I'm try...
(2) odpowiedzi
2017-05-22 19:05 Update with inner join Postgresql »
Because doing this update does not work for the where clause? The update does it for me all. UPDATE ventas SET eav_id = 7 FROM ventas AS A inner joi...
(2) odpowiedzi
2017-05-22 19:05 Serialize/Deserialize list of POJOs using Jackson to/from JSONB column - Postgres 9.4 »
I have created a custom UserType for my class and want to map the list of POJOs to JSONB column in the database. Added JSONB column to my table A...
(0) odpowiedzi
2017-05-22 11:05 postgres trigger creates index: BEFORE INSERT ON hides one row »
I have a trigger AFTER INSERT ON mytable that calls a function CREATE OR REPLACE FUNCTION myfunction() RETURNS trigger AS $BODY$ DECLARE ...
(1) odpowiedzi
2017-05-17 19:05 Pass array of tags to a plpgsql function and use it in WHERE condition »
I'd like to create a function that returns items based on their tags. However, I do not know how to format an array in the IN() clause. I believe that...
(3) odpowiedzi
2017-05-17 18:05 Disable stemming for specific words with Postgres Full Text Search »
With Postgres full text search I'm using the default english dictionary, which mostly works for our purposes but there are a few cases where stemming ...
(0) odpowiedzi
2017-05-17 04:05 query case when postgresql »
I have query like this : select case when code=31 then name end as name1, case when code=32 then name end as name2 from master where code=31 ...
(1) odpowiedzi
2017-05-16 20:05 Barman recover command not copying "all" WAL files to standby database server from on Barman server »
What is wrong with the recover command that isn't transferring these WAL files? barman recover --target-time "2017-05-16 16:39:02.235780+00:00" \ --r...
(0) odpowiedzi
2017-05-16 09:05 PostgreSQL - Extract data no older than 2 days »
I have a PostgreSQL database in which I store data that has the following rows: ------------------------------------------------------ | id | did...
(0) odpowiedzi
2017-05-15 05:05 Weird Postgres Xlog »
I have question about Postgres xlog. According the Postgres documentation, the Postgres xlog should be in this format 0000000100000044000000FE, i don ...
(1) odpowiedzi
2017-05-11 16:05 Reseting a sequence (case sensitive) »
I try to set a sequence (test_Id_seq) to a new value like that (notice the upper case letter 'I' in the sequence name): SELECT setval(public."test_Id...
(1) odpowiedzi
2017-05-09 08:05 SELECT a column from another table based on another table's value »
Ok so the title is bit of a mess, but I have a table city like this: id | name | population 1 | Bla bla | 1323 2 | Blaer | 35365 Now I'm ...
(3) odpowiedzi
2017-05-09 01:05 How to query for records with associations that either don't exist or all have non-null value? »
I have a tasks table in Postgres is 9.4.7 like this: goal_id | expires_at 1 | null 1 | 2017-05-3 2 | null 3 | 2017-05-3 ...
(1) odpowiedzi
2017-05-08 15:05 Postgres Copy data from two file in two table »
I am trying to execute the \copy command to insert data to two tables from two files (The relations about then are master, details), to insert into th...
(0) odpowiedzi