PostgreSQL Database Forum

Where can I find sample database with tables used in the Postgresql documentation to download ( used here for example : https://www.postgresql.org/docs/current/static/queries-with.html )

That I want to ask is if I can return type A or B in the function depending of a parameter. For example CREATE or replace FUNCTION public.getDataFromSearch( searchString VARCHAR, typeOperation INTEGER) RETURNS SETOF typeA OR typeB AS ... If typeOperation is 'A' can I return a query with the structure or typeA and if is 'B' the...

I am new bee here, I have been working as Oracle DBA from past 5 years, now there is a requirement to learn Postgreysql. Please guide me to get certified.

Can u please explain internal process of backup?

Hello, I am new to PostgreSQL and i would like to achieve the same result as a stored procedure in MSSQL returns. In SQL i can return the output of the query with out defining any return type. Eg: Create procedure mysp (table_name varchar(25) as begin

how to set up master-master replication in pg

How much memory required to achieve performance with the 6GB RAM, 8 Core, Max connection 1100 concurrent connection and O/p memory from procedure 1GB ?

I am converting mssql to postgresql , can i know how to use nvarchar in postgresql

Hi to All, I have a table articles. If I made the simple query: SELECT name, quantity From articles; I obtain the name and the relative quantity of each row in the table articles. But, now the question is:

Dear Community Users, I am facing issue while upgrading Database 9.2 to 9.6 and using method pg_upgrade. Check mode was failing with following error, could not load library "$libdir/pg_reorg": ERROR: could not access file "$libdir/pg_reorg": No such file or directory I have verified the Library pg_reorg and its not present on both ...

I wanted to use pgadmin to manage Postgresql database, getting error no module named flask_login when executing python pgAdmin4.py.Also ran pip install Flask-Login no resolution for the error, kindly guide me how to fix the issue..The image is herehttps://ibb.co/7pF4wBR

I am using Postgres 9.6.9. I am facing a strange issue with using limit with offset. Without any limit and offset conditions, I get 9 records. If I give conditions like- OFFSET 1 LIMIT 3

I have a postgresql cluster with following databases with user myuser: database1 database2 I have setup a replication with one master(192.168.50.8) and slave(192.168.50.9). I failover to slave and when i try to failback to original master using pg_rewind for every database, pg_rewind gets succeed for first database but fails for second...

Dears, I had a Cluster running Master1-Master2 replication. After a Master1 disaster recovery backup, Master1 is running as a Slave of Master2. It is only possible to sync database configuring tables on Master2 to replicate to "Master 1". What can be done to restore initial scenario? Regards

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...

Hello, I am not a Postgresql user (yet). I need a database that can do what all sql databases do, index data but, I also need that database to index plain text documents for text searches. I know that Postgresql is a very capable sql database but, even after doing some research, I am unclear as to whether or not it would be well suited to...

Hello, I have to change cache for all sequences in schema and database.I can not change one by one.My question, is there some script or query which can change cache size for all sequences ??Please help me. Best regards

I have a requirement to delete records from a Postgres SQL table which has more than 200 million records. The table is not having any primary key. The sample table (Bookmark is the name of table) content is as below: systemId filename mindatetime maxdatetime 70277 monitor_1.dat 2019-04-21 08:00:00 AM 2019-04-21...

Team, Following takes to much time infact its running since more than 36 Min so. update dbo."UnitStatement" set "Value" = "UnitChange" * "NAV"; #records - 2211664

HI, We are working on Oracle to Postgres migration. Could you please suggest how to convert or replace with equivalent of "Pipeline" function in Postgres. Regards Arun

I have installed postgresql 9.6 on my CentOS 7 VM, but i can't specify parameters in the initdb command. In Ubuntu i do this in this way: su -p -c "PATH=/usr/lib/postgresql/9.6/bin:$PATH initdb --locale=it_IT.utf8 --lc-collate=it_IT.utf8 --lc-ctype=it_IT.utf8 --lc-messages=C --lc-monetary=C --lc-numeric=C --lc-time=C -- encoding=UTF8 -D...

One of my clients is facing PostgreSQL installation failures through postgresql installer binary "postgresql-9.6.6-1-linux-x64.run" on CentOS 7.6 server. The error in /tmp/install-postgresql.log is given below.... performing post-bootstrap initialization ... Failed to initialize the database cluster with initdb with the error "invalid byte...

I have a text column named bid_xml in my table which has the following value: <?xml version=1.0 encoding=UTF-8?> <dpid:DpidDatabase xmlns:dpid=http://ddex.net/xml/dpid/11 xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance xsi:schemaLocation=http://ddex.net/xml/dpid/11 http://ddex.net/xml/dpid/11/dpid.xsd> <DpidOwner SequenceNumber=1> ...

I am new to postgres and in the process of assessing its implementation at our company. Postgres is open source, but we would like to go with a vendor managed product. I went over the postgres link that has several vendors listed, but I would like to get feedback for a few vendors. We are a large company and looking for all the necessary...

Hi all, Can you please let me know how to install PostgreSQL 9.1 on Ubunut 18.04 with ldap modules. When I am trying to restart the postgres server after making changes to the pg_hba.conf to use ldap authentication, I am getting the message as invalid authentication method "ldap": not supported by this build Thanks and regards...