PostgreSQL Database Forum

Please follow this site's Posting Guidelines when posting questions or answers. Some highlights from the Guidelines: Make a meaningful title for your thread. "Please Help!" is not one of those. Include your code snippets into the CODE tags; use the menu icons on the GUI. Provide enough information, so others can help you. This may include...

hello i have my data stored in different Ms Excell sheets. now I am planning to make a database of the data i have. but i m confused whether to use Postgresql or mySQL for the same. i had plans to import data directly to Ms Access but there is problem with my access for now so i have to think of other choises. i wanted to know whether it is...

Hi, I have written a procedure with multiple input parameters but while calling the procedure, i am facing the error. Procedure: CREATE OR REPLACE PROCEDURE public.sp_create_svc_accounts( IN orgid integer, IN bggroupid integer, IN vclabel character varying, IN traffictype character varying, IN channelcode character varying, IN...

Hi everyone! I have a problem that I should solve in postgres sql, but I'm stuck. The bare data is a table named activity_logs : activity_time (timestamp) | action (int4)|item 1 (varchar) | item 2 (varchar)| This is a log table simplified. activity_time: is a timestamp when a user login/logout is attempted. Action: can be 1 - Login or 2 -...

Dear Friends, I have 2 tables in Postgresql. Table1 and Table2 .... There is a common field Table1.ARN and Table2.RN . My need is get all the data of second table which is not in the common data get by Table1.ARN=Table2.RN. Waiting your fast reply Thanks Anes P A

I found unexpected command that took max CPU Usage on Postgres database server https://ibb.co/7NfSV5C

Hello, I have one query, written MySQL language, and there qork perfectly. But I like to use the same query, in postgreSQL and there get 2 times syntax error, and I'm not fing the issue. Here is my code: UPDATE "T_Status_Furnace" SET "Status_CG" = true WHERE EXISTS ( SELECT MAX(m2.t1 - m1.t1) as delta FROM "Table_1_Furnace_1" AS m1 ...

We have setup an environment of Postgres 15 cluster thru etcd and patroni with the help of HAProxy. Can we use any commercial load balancer in place of HAproxy ? Like F5 or Fortigate

Hi. In one recent research, i fails to understand of how PostgreSQL work with physical memory when executing a queries. Perhaps, someone had experience in the analysis of this issue. All tests was acted on PostgreSQL 12, Debian 10. In first, we have an execution plan of query. The execution plan contains HASH JOIN operations (search by query...

Hello, I'm fairly new to PostgreSQL and have a situation where I need to flatten a text column to two separate columns. Below is the query I'm using: SELECT s.CoolerShelf, s.ShelfPosition, FROM planogram CROSS JOIN LATERAL UNNEST(string_to_array(shelves, ','))

These are the steps of indexing in Lucene given in our syllabus-: <Broken Link> I understand the second step clearly. But I don't understand the first and third step. It's not mentioned clearly in this figure imo. Can you clear my confusion? Plus the sources that I refer don't even mention it like this, they explain it differently. I'm not...

I really need advice on the below, trying to use DB function getpreviousorders.. NOTE: But this DB function got much faster if run directly on DB, without data reference entity data by spring hibernate code in Order entity. CREATE OR REPLACE FUNCTION "sample"."getpreviousorders"("_sampleid" varchar, "_mrn" varchar, "_createddate" timestamp)...

Dear All, I have been facing below issue when trying to export table data in CSV format only when used where condition. I dont see any issue if I dont use where condition. Eg: Succesfully copied to CSV dnsdb=> \copy domains to '/root/pgdata/mycsv.csv' csv; COPY Failing with below error when added where condition

Hi, I need to encrypt one of the existing column data and perform full db backup and share that to dev team. Please share any tools available to do that. Thanks.

Im a newbie in PostgreSQL. I have a mysql insert query in c++. You can see it below. I want to convert mysql db to postgresql. Im using #include <postgresql/libpq-fe.h> for it. Here is my mysql code: pstmt = con->prepareStatement("INSERT INTO public.comp_inventory(epp_mac_address,epp_data) VALUES (?,?)"); pstmt->setString(1,...

Q: How to update properties value in the array of jsonb field? Hi All, I run Postgres13 (PostgreSQL 13.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit) I have a jsonb field type (fieldname is test), like below JSON array format, how to update is_read properties in extras node to true where the...

Hi All, I can connect to the postgresql db using SQL Developer, but when I tried to configure using ODBC Data Source Admin, I get the following message "could not translate host name "abc.com:5432/db?" to address: unknown host" Please advice. Thanks

Hello everyone, I moved all tables and indices out of a tablespace to a different tablespace (different hard drive and different mountpoint). Now I want to drop the old tablespace but it says the tablespace is not empty. If I go into the tablespace directory i see bunch of files. I was told that these cannot be deleted, but if I'm trying to...

Hi Team, We have used PG_DUMP to take backup of particular database from the PostgreSQL Server. It takes too long to restore the databases , which has Half Billion records (almost 8 Hour) My primary need is to make the Differential and Incremental backup on the Windows Server. When I search there is a tool Barman and...

Our software configurations are below Database: PostgreSQL 14.1 Version OS: Windows Server 2019 We have taken the database backup from PgAdmin 4.0. Per day almost 4.5 Million records will be inserted on my database, so we need the differential and incremental backup option In Microsoft SQL Server there is an option to take...

I am using postgresql 10, and when I created a table with two variables, the lock signs(shows read-only column) were shown on the columns. I am not sure if it is a reason that makes me can not import csv file into table. if so, how can I remove that? https://i.stack.imgur.com/kIiRX.png

Background: I have been working on a sport card database for a long time in MS Access but am at a point where I needed to enlist help from a former colleague who specializes in Oracle, SAP, PostgresSQL. Summary: In MS Access I had so many M2M relationships that were handled through I believe what are called bridge or junction tables. My...

Hi Folks, As a SQLDBA, I am currently learning PSTGR Administration, and I have gone through Database Architecture. SQL database has two files: a data file and a log file, and all DML transactions are logged to the log file before writing to the data file.. when log files gets full, we shrink the files. How does Postgre compare to SQL log...

Hi everyone ! I have to recover a database created under PostgreSQL 8.1 (Windows 2000 Professional) from a damaged pc but I have the PostgreSQL installation directory of that pc. I want to install version 8.1 on a new pc in order to recover the database. I searched all over the internet but I can't find PostgreSQL 8.1 for Windows. Does...

Hi, WAL files are not getting cleared even after reaching wal_keep_segments and grows gradually , finally ended up with high disk space utlization. below is the configuration in postgresql.streaming.conf. Please help to solve this issue listen_addresses = '*' wal_level = 'hot_standby' max_wal_senders = 10 wal_keep_segments = 100...

Hi, I need to know for many table on my Postgres11 when many fields has been created or modifiy ? I don't see infomation in information_schema.columns Regards