Tagged Questions
0
votes
1answer
29 views
Can a connection's prepared statements be altered by Postgres's admin functionality? [closed]
I am trying to tamper proof as best as possible a peer to peer application.
I am concerned that the prepared statements will be altered.
Can the Postgres admin alter a connection's prepared ...
0
votes
0answers
8 views
Problems with PostgreSQL and ESRI Geoportal Installation on CentOS
I am installing geoportal 1.2.4 on CentOS from the command line terminal...during my installation I am receiving a fatal ident error message for my user geoportal. The pg_hba.conf file has been ...
1
vote
2answers
40 views
PostgreSQL/ Linux, way to have DNS forward to a port/cluster?
Aws linux(centos) ec2
Host: mydb. 10.10.10.10.
3 clusters: ports 5432, 5433, 5434
What I'd like to see is:
db2.mydb or mydb/db2 connect/fwd to cluster2 (5433).
Anything Linux or psql come to mind? ...
0
votes
1answer
55 views
Issue working with Postgres on Windows
I am running PostgreSQL 9.3 on my machine. I have PhpPgAdmin running on a cloud, using which I exported the database I am supposed to be working on, selecting "Structure and Data" and "Download". ...
1
vote
0answers
103 views
PostgreSQL refuses to listen on IP [closed]
This was a case of PEBKAC. By default, the listen_addresses line in postgres.conf is commented out. I failed to notice this and remove the comment.
I'm trying to get a PostgreSQL 9.3 server up and ...
0
votes
4answers
800 views
PostgreSQL 9.3 on Ubuntu Server 12.04 v.s. MS SQL Server 2008 R2 on Windows 7 Ultima
I have searched many articles in Google about the performance of PostgreSQL vs MS SQL 2008 R2 and found that many of those articles say the performance of PostgreSQL is better than that of MSSQL 2008 ...
0
votes
1answer
276 views
Unable to Start PostgreSQL. kernel's SHMMAX parameter exceeded you limit
When I am trying to start my PostgreSQL I get the following error in the Postgresql.log file:
FATAL: could not create shared memory segment: Invalid argument
DETAIL: Failed system call was ...
0
votes
1answer
160 views
Postgres memory usage too low
I have a 400GB Postgres 9.3.4 DB running on Fedora20, and a few indices per table. I have upped shared buffers to 4GB (the system has 16GB available), set shm in the kernel and set the ...
1
vote
1answer
121 views
Trouble with installing additional modules on Postgresql 9.1 on ALT-Linux
I'm trying to create extension under postgresql 9.1 (Linux):
CREATE EXTENSION pg_trgm;
but got error:
ERROR: could not open extension control file "/usr/share/pgsql/extension/pg_trgm.control": No ...
0
votes
0answers
66 views
Postgresql on Slackware 14.1 (64-bit) Cluster Error
I am attempting to install Postgresql Database on Slackware 14.1. However i am getting an error: Problem running post-install step. Installation may not complete correctly The database cluster ...
2
votes
3answers
854 views
Counting postgres open connections without SQL query or connecting to postgres itself
For a monitoring script I need to count the number of open connections to a postgres database. This is done easily enough by opening up a client connection and running a count on the pg_stat_activity ...
0
votes
0answers
165 views
Postgres Backup on linux server [closed]
I am trying to take backup of postgres from InstallAnyWhere which is installer for linux and windows machine.
I am calling pg_dump from Java process builder as command line below
cmdLine: ...
0
votes
1answer
247 views
PostgreSQL - pgAdmin error creating a server
I have the latest versions of PostgreSQL and its GUI-frontend, pgAdmin, installed.
When I try to register a new server a fatal error appears when pgAdmin tries to connect to the newly created server - ...
1
vote
1answer
240 views
Grant postgres superuser to linux account
On my development (Ubuntu linux) laptop I have a postgres OS account, which owns the Postgres installation.
When I want to perform any postgres activities, create/drop databases etc, I must first su ...
0
votes
1answer
71 views
How can I run a PostgreSQL outside the standard directories on Linux, ie outside /var/run/postgresql etc?
I need to be able to run PostgreSQL databases outside the standard installation directories, ie run the existing postgres or pg_ctl process pointing to the alternative ports, configuration and data ...
1
vote
1answer
445 views
PostgreSQL transaction locked database table: “idle in transaction”
I have a web application interacting with PostgreSQL (v8.4 & Centos Linux) which suddenly started locking some of the database's tables. Still have no idea what happened, since the code is not ...
1
vote
2answers
1k views
How to set password for PostgreSQL database with a script?
In a bash script I'm writing, I need to create a database and set a password that is generated automatically by my script.
The problem is I can't find a way to set up the password without user ...
0
votes
0answers
697 views
postgres service suddenly not working after the computer crashed while working
I've been working with postgres on a linux server for the last couple of months. Last week, half of our servers crashed and my one with them. I was in the middle of uploading data to the postgres ...
0
votes
0answers
745 views
Server doesn't listen
I try in Win7 by means of PGAdmin 3 to be connected to a host 192.168.1.8 with the virtual machine with linux. Already which time I receive the message
Server doesn't listen
The server doesn't accept ...
1
vote
1answer
838 views
Moving postgresql data directory
I moved postgresql's data directory by following the following steps:
Stop postgres
cp -a source_data_directory destination_data_directory
export PGDATA=destination_data_directory
Changing data ...
1
vote
0answers
308 views
How to Change location of postgres cluster and database within the same machine? [duplicate]
I have my present database cluster of postgres at /mnt/my_hard_drive which I want to change to /home/myfolder. I also want to move all my databases present in the present cluster to /home/myfolder. Is ...
3
votes
0answers
118 views
What happen when Postgresql tablespace is null?
I'm facing a DWH on postgresql with no DBA (I'm not one) so I turn to you with hope to figure this issue/s.
Long story short, when I check the disk usage per tablespace, I get different distribution ...
0
votes
0answers
1k views
createdb: could not connect to database postgres: FATAL: could not write init file [closed]
RedHat Enterprise Server 3.0 32 Bits
psql (PostgreSQL) 8.2.3
user: postgres
server is running:
/soft/postgres/8.2.3/bin/pg_ctl start
pg_ctl: another server may be running; trying to start server ...
1
vote
1answer
129 views
clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
After a fresh PostgreSQL install (version 9.2) on my Ubuntu server 12.04, clusterdb utility stopped working. I used the same config files as I used with version 9.1.
Below is the actual command:
...
2
votes
2answers
1k views
issues with encoding and pg_dump/restore between windows and linux
I have a dmp file I have created using pg_dump encoded in WIN1252. What I would like to do is import it using pg_restore to a database on a Linux machine. The problem is that on the windows machine ...
1
vote
2answers
927 views
Postgresql - Segmentation fault (core dumped)
I'm working on postgresql code (server side).
I installed a version from source code following the official tutorial:
http://www.postgresql.org/docs/8.4/interactive/install-short.html
I did same ...
0
votes
2answers
2k views
Open source alternative to SQLMaestro for PostgreSQL
I'm looking for oen source alternative to SQLMaestro for PostgreSQL because it has visual database designer which not avaliable in pgAdmin which make database desinging so easy.
PS I'm not sure if ...
0
votes
1answer
683 views
How to Restore Postgresql Cluster from data directory
in our office we have a development database server that runs Debian 5, on this server we had a postgresql 8.1 running but because of the lack of internet access from the server we backed up with ...
0
votes
0answers
338 views
multiple postgreSQL running as primary server on pgpool
I'm facing problem with my pgpool setup. Currently, this is my requirement based on the pgpool documentation here :
Server A : Install with PostgreSQL database. Run as primary server
Server B : ...
1
vote
1answer
371 views
PostgreSQL 9.1 - Asynchroneous commits performance boost
During peak hours our users experience a lot of timeouts due to an overloaded database server. We are currently trying to make optimizations in order to cope with the high traffic. We read in the ...
0
votes
1answer
2k views
Pgpool install - libpq is not installed or libpq is old
Based on the documentation here, I want to create a pgpool II with PostgreSQL databases. When I try to install, I encounter this error:
configure: error: libpq is not installed or libpq is old
...
3
votes
1answer
1k views
How can I create a dblink from Postgresql 8.3 to SQL Server (2000 and 2008)?
I have a Postgresql database that need to read data from two SQL Servers (one SQL Server 2000 and one SQL Server 2008).
I want to setup two dblinks to the SQL Servers.
After googling, foruming, ...
8
votes
2answers
446 views
High Availability for postgresql
I'm new in PostgreSQL database. Recently our developer needed to do some upgrades in our systems.
Because of that we are planning to implement some method in order to implement database failover.
...
7
votes
1answer
3k views
Starting PostgreSQL server after a HDD crash results in FAILED STATE
I am using Fedora 15 with PostgreSQL 9.1.4. Fedora crashed recently after which:
An attempt to start the PostgreSQL server :
service postgresql-9.1 start
gives
Starting postgresql-9.1 (via ...
2
votes
1answer
720 views
Tune postgres 9.1 to speedup deletes
I need to tune my postgres db to speed up delete queries. I cant't optimize my db structure yet, so I'm looking for options available on server level for postgres 9.1.
I've seen in older posts the ...
4
votes
2answers
6k views
Easy Postgresql master/slave replication with automatic failover on Linux?
I need a reliable SQL DB for our application and have been looking at Postgresql's streaming replication support. It seems that it's not hard to setup master/slave replication and you can use the ...
3
votes
2answers
3k views
Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu)
Please suggest a tool to reverse engineer a PostgreSQL DB into an entity-relationship-diagram (ERD) or equivalent ??
Ideally, I'm looking for a simple ERD or UML class diagram in a format that is ...
1
vote
1answer
615 views
Tutorial for installing and setting up 'streaming replication' with PostgreSQL on Windows XP
Please refer to the diagram in the link below. While looking at my goals.
http://i.stack.imgur.com/GkVWb.png
GOAL:
Get PostgreSQL 9.1 running on 3 terminals on the 'on site' location.
'on ...
8
votes
2answers
2k views
View Postgresql Memory Usage
I'm running Postgresql on a Ubuntu server and need to be able to monitor its memory usage. Currently I have scripts running in a one-minute cron job that monitor/log various statistics and need to ...
9
votes
3answers
4k views
How to convert mysql to postgresql?
I am desperately looking for a conversion tool to convert a big mysql database to postgresql. I need the tool/script to be:
Free
Works under Linux
Simple to use and not buggy
You actually tried and ...
3
votes
1answer
2k views
Any Idea how to migrate from PostgresSQL 8.4 to PostgresSQL 9.1.1 in opensuse12.1
I had a crashed opensuse 11.3 that's why I installed opensuse 12.1..
after I installed (via yast) and edited /etc/passwd
I do this:
rcpostgresql start
and this shows on the /var/log/messeges
~ ...
