Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: postgresql-9.1

Find current owner of custom data type?

By adminPosted on February 7, 2023

Question : In Postgresql, when I try to run ALTER TYPE x ADD VALUE y; on a custom datatype I […]

copy command in postgresql to append data

By adminPosted on February 3, 2023

Question : I am executing copy command from a function execute ‘copy (select * from tableName) to ”/tmp/result.txt”’ It works […]

Very large btree index with few rows (openstreetmap gis data)

By adminPosted on February 3, 2023

Question : I tried to import a subset of open street map data to a Postgres database using the standard […]

Granting access to all tables for a user

By adminPosted on January 27, 2023

Question : I’m new to Postgres and trying to migrate our MySQL databases over. In MySQL I can grant SELECT, […]

timeline 2 of the primary does not match recovery target timeline 1

By adminPosted on January 24, 2023

Question : I want to create a configuration with postgresql and pgpool to get height availability (HA). I want to […]

Adding nullable column to table costs more than 10 minutes

By adminPosted on January 24, 2023

Question : I have problems to add a new column on a table. I tried to run it a couple […]

Howto disable Postgres listening on TCP?

By adminPosted on January 23, 2023

Question : Simply to avoid many problems in the first place I do not want my postgres server program to […]

Postgres automatic insert time stamp with time zone (india) [closed]

By adminPosted on January 20, 2023

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

Trigger for removing group with no users left in

By adminPosted on January 18, 2023

Question : I have three tables: USERS, GROUPS, and GROUP_MEMBERSHIP CREATE TABLE USERS ( ID BIGSERIAL NOT NULL, NICKNAME VARCHAR(20) […]

Cannot connect to server. Too many symbolic links. Postgres Error [closed]

By adminPosted on January 6, 2023

Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]

  • 1
  • 2
  • 3
  • …
  • 19

Recent Posts

  • postgresql grant user privilages to dynamically created tables
  • How can streaming replication be kept lagged by a certain ‘delay’ time?
  • Query for similar syllables on a field
  • Write filename, servername/IP and date+time in spool file
  • Designing a table with multiple null FKs
  • I am trying to get the string between hyphen (-) which is before (+) upto next colon (:)
  • Why would a SELECT INTO cause an arithmetic overflow?
  • Possibility to implement time to execute / TempDB usage restrictions on some role groups in SQL Server?
  • Login failed for user – Error 18456 – Severity 14, State 38
  • comparing two values in same column with another column using AND condition
  • Slow running aggregate of aggregate query
  • Is it possible to get seek based parallel plan for distinct/group by?
  • PostgreSQL replication: out-of-sequence timeline ID, when former master made slave
  • Autogrowth Analysis in PROD DB based on the trace file data
  • Single versus Multiple databases
  • Does a user who has permissions to select from a view also need select granted to the children entities of that view?
  • Parse a string to find data between delimiters, multiple occurrences
  • Oracle multiple databases on same server [closed]
  • Help to create indexes to improve query performance and reduce report generation time
  • Error while granting select privilege

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding