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

Tag: postgresql-9.2

Setting up binary replication between two PostgreSQL instances

By adminPosted on March 29, 2023

Question : I have two virtual machines: dbrepa (-.175) and dbrepb (-.191). Both have PostgreSQL 9.2 installed; once PG was […]

PostgreSQL: Executing DDL on every schema

By adminPosted on March 15, 2023

Question : I’ve a multi-tenant DB setup, and need to add some columns. I’m using schemas (and search_path) to partition […]

Sequential scan with large sub-query filter “never” ends

By adminPosted on March 10, 2023

Question : I’m using postgres 9.2.4, and run the following query: explain analyze select * from bubu where id not […]

Performance impact of setting PostgreSQL to log all statements

By adminPosted on March 9, 2023

Question : PostgreSQL 9.2.2 on Windows 7 64-bit. The setting log_statement in the postgresql.conf file specifies what statements to log […]

Upgrading using pg_upgrade on windows fails

By adminPosted on March 5, 2023

Question : When upgrading from postgres 9.2 to 9.3 by following the upgrade procedure found in PostgreSQL 9.3.4 documentation about […]

Streaming replication between postgresql 9.2 and 9.3

By adminPosted on February 21, 2023

Question : Does anyone know if it’s problematic to have a postgresql 9.3 slave setup to do streaming replication from […]

how to track progress of a large postgres dump

By adminPosted on February 20, 2023

Question : Is there a way to see the progress of a pg_dump operation on a big db (ie > […]

Error: Unable to write inside TEMP environment variable path

By adminPosted on February 13, 2023

Question : I am installing PostgreSQL 9.2.4-1-windows.exe on Windows 7 64 with Service Pack 1. I get the following, rather […]

Why does Postgres generate an already used PK value?

By adminPosted on February 9, 2023

Question : I’m using Django, and every once in a while I get this error: IntegrityError: duplicate key value violates […]

pg_ctl status responds with “available” during failed startup

By adminPosted on January 29, 2023

Question : I am using pg_ctl -D $PGDATA status to monitor whether my postgres standby database is up and running. […]

  • 1
  • 2
  • 3
  • …
  • 19

Recent Posts

  • InnoDB engine is not loading after tuning parameters
  • How to optimize query on MYSQL with multiple group by clause
  • Referencing database programmatically via T-SQL
  • How to set roles and users with correct permissions on Postgres? [closed]
  • SQL query optmization [closed]
  • Is it possible to optimize this query? Currently taking days (no sign of stopping) on ~11 million records
  • We use MongoDB 3.6 community version, How can i get the number of hits on single collection as well as bandwith usage?
  • Will too many tables slow Mysql down?
  • Group By hour over large dataset
  • “Force Encryption” vs “Force Protocol Encryption” in SQL Server
  • Mysql checksum for master-slave replication returning different values, despite being identical
  • Same record shows up multiple times in ordered paginated query
  • Allow users to only view the databases they have access to
  • Does ALTER on PostgreSQL, Oracle table (respectively) create intermediate copy of the table?
  • Delete rows from a large table with joins and aggregating (resulting in 1 % less rows in the big table)
  • How to record sqlplus session activity like “/var/messages” in Unix..? [closed]
  • Mysql dump with View dependent on user
  • How does Oracle know who I am?
  • Filter a SQL replication
  • Return values from Left Table Only Once

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