Questions tagged [postgresql]

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.

Filter by
Sorted by
Tagged with
1 vote
1 answer
11k views

Invalid command 'php_flag', perhaps misspelled or defined by a module not included in the server configuration

I'm trying to setup PhpPgAdmin. But the service won't start. I get the following output when sudo systemctl status httpd.service: ● httpd.service - Apache Web Server Loaded: loaded (/usr/lib/...
andrdc's user avatar
  • 21
1 vote
1 answer
2k views

How to connect AKS with postgres in private vnet?

I have created postgres with private vnet option. So, no direct access to posgres from internet. But, I can't access it from "CloudShell" also. Also, while creating database,when I want to ...
Sara June's user avatar
  • 521
1 vote
0 answers
1k views

Production server much slower then local test server when sending large request

I am running a django app and I am trying to send an API POST-request which is pretty big to my production server. Now the problem is that what takes 4 seconds locally takes 1 minute in production. ...
Micromegas's user avatar
1 vote
5 answers
2k views

how to speed up a database - hardware only

simple question - what is the best way to improve a database's performance using hardware only? in this situation a few very very large tables are being queried very regularly by 1-4 processes at a ...
pstanton's user avatar
  • 673
1 vote
1 answer
12k views

PostgreSQL is out of control: high cpu load, high memory consumption [duplicate]

I'm using PostgreSQL 9.2.32, installed on CentOS 7 with Plesk, with a very small amount of tables (the tables are small too) and Vapor 3 as backend. After a few hours, my server is out of memory, ...
Pascal Friedrich's user avatar
1 vote
1 answer
3k views

Empty error on starting almost-default PostgreSQL

When trying to start PostgreSQL, I get this 'empty' error message: root@mountain-lion:/home/ubuntu# service postgresql start * Starting PostgreSQL 9.1 database server * Error: could not exec /usr/...
Bart van Heukelom's user avatar
1 vote
1 answer
2k views

PostgreSQL v9.3.4 memory usage Issue on Windows Server 2008 R2

I have DB of size ~16GB Windows Server 2008 R2 (up to date). We moved from Postgres v9.2.4 to Postgres v9.3.4 and now Postgres v9.3.4 memory usage is growing until is takes all the windows physical ...
bhlabhlabhlabhla's user avatar
1 vote
1 answer
892 views

Backup broken PostgreSQL 8.4 without pg_dump

So. I have a problem. PostgreSQL 8.4 won't start or restart without any output given. But it worked for 3 monthes until hosting provider doesn't rebooted server. Now it is completly broken. It wan't ...
Daniil Ryzhkov's user avatar
1 vote
1 answer
703 views

Invalid byte sequence for character encoding 0x00 after upgrading from 8.3 to 8.4

I'm trying to upgrade a database from PostgreSql 8.3 to 8.4, I backed up the data from 8.3 and restored from 8.4 without issues, but, when I try to use the same program that is working perfectly ...
Leonardo Ramé's user avatar
1 vote
1 answer
697 views

Can't create clusters in PostgreSQL 9.0

I'm trying to setup and run multiple clusters of PostgreSQL 9.0 in the same Ubuntu/Debian machine. Debian has a package called 'postgresql-common' to facilitate managing database clusters. However, ...
user avatar
0 votes
2 answers
4k views

postgres on 64 bit linux or 64 bit windows server 2008?

Postgres does not have a 64 bit binary for windows server quote "As there is generally no reason to run with shared_buffers > 256 - 512MB on Windows, there isn't a great deal of incentive to put in ...
pstanton's user avatar
  • 673
0 votes
1 answer
2k views

Database connection to postgresql refused for flask app under mod_wsgi when started by systemd

I'm having a weird problem where a flask application I am trying to run (https://github.com/pyfarm/pyfarm-master) under mod_wsgi under Apache under CentOS 7 cannot connect to a local postgresql server ...
guidow's user avatar
  • 3
0 votes
1 answer
1k views

Why is autovacuum using so much IO when running on a partition's master table after upgrading PosgreSQL from 8.4 to 9.1?

We have an application where we are collecting timestamp-based data. Since a month of data goes over 30M rows (and growing each month), we decided to partition the data on an year-and-month basis. We ...
Vlad's user avatar
  • 187
0 votes
1 answer
2k views

How to access postgres in private vnet from another VM in azure?

I have created postgres flexible server with private vnet option. So, no direct access to posgres from internet. But, when I try to create a new windows 10 VM, I can't select the subnet of database ...
Sara June's user avatar
  • 521
0 votes
2 answers
2k views

PostgreSQL processes and the signals to which they respond

For PostgreSQL 8.3 and later, what are the processes that make up the server and that respond to a query? What signals do the various processes respond to and what effect do the signals have? What ...
Bribles's user avatar
  • 1,004
0 votes
1 answer
265 views

Use SQL views instead of tables with Asterisk dynamic realtime

I had hoped that I would be able to use an SQL view instead of a table to provide e.g. iaxusers and iaxpeers to Asterisk via dynamic realtime (ARA). I have just noticed that iaxpeers apparently ...
Drux's user avatar
  • 696
0 votes
1 answer
7k views

How to set up port forwarding for postgresql listening on localhost?

I have a postgresql instance running on SLES. I want to set it up to listen on localhost, and enable iptables to perform port forwarding. My current configuration postgresql.conf: ...
David Resnick's user avatar
0 votes
3 answers
6k views

Change data path for PostgreSQL

I run PostgreSQL as a Service. In Administration - Services, I can see the following path "C:\Program Files\PostgreSQL\8.4.3-3.1C\bin\pg_ctl.exe" runservice -w -N "pgsql-8.4.3-3.1C" -D "C:\Program ...
user avatar
0 votes
2 answers
449 views

Problem in creating UDP sockets

Our production server is running PostgreSQL v8.2.3 on Red Hat Enterprise Linux Server release 5 (Tikanga). For some reason, statistics collector in PostgreSQL is not working. Even posted this ...
Gnanam's user avatar
  • 1,479
0 votes
1 answer
5k views

Strange permission errors in new PostgreSQL installation

A freshly installed PostgreSQL (with configuration overwritten) won't start: $ sudo service postgresql start * Starting PostgreSQL 9.1 database server * Error: could not read /etc/postgresql/9.1/...
Bart van Heukelom's user avatar
0 votes
1 answer
2k views

Connect to and reindex Postgres database with system table errors

I've got a Postgres database that crashed (as well as the disk) and suffered some data errors (per After DB disk failure, now "cache lookup failed for index"). The initial problem seems to ...
bennylope's user avatar
  • 103
0 votes
1 answer
4k views

After DB disk failure, now "cache lookup failed for index"

After resolving some problems with the network drive on which our Postgres database was hosted, we encountered this error: OperationalError: FATAL: cache lookup failed for index 2662 That ...
bennylope's user avatar
  • 103
-2 votes
1 answer
2k views

Many Postgresql process. how to handle them?

I'm trying to fix an already install openNMS system on ubuntu. Currently I'm facing issue with postgresql. I stop server using this commnad: service postgresql -$PGVERSION stop after that when i run ...
Kashif's user avatar
  • 513

1
2