PostgreSQL is a powerful, enterprise class, open source RDBMS. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability and data integrity. It runs on all major operating systems, including Linux, UNIX and Windows. It prides ...
0
votes
0answers
3 views
(newb) Issues starting Postgres server
I'm trying to go through the book "7 Databases in 7 Weeks" and I'm completely stuck at starting a Postgres server.
My current issue is that when I run pg_ctl start I get the following error:
LOG: ...
0
votes
0answers
16 views
PostgreSQL 9.1.4 will not install service scripts
Same setup as before, but with a different install command.
PostgreSQL refuses to install its service scripts into /etc/init.d/; in fact, I can't find them anywhere (find / -regex ".*postgres.*")
...
0
votes
0answers
17 views
Calculating the row size of a table [duplicate]
Is there a way to calculate the row size (in bytes) of a particular table in postgresql / pgadmin3?
0
votes
0answers
9 views
Using PL/R for clustering geometries
I have a Postgres/PostGIS database of geography points which I'm trying to cluster; meaning I want to group and count them by proximity. I have had first success with the kmeans Postgresql extension, ...
0
votes
0answers
16 views
Difficulties in createing a PostgreSQL Database
I am a very beginner with Data Base programming and I am trying to create a new postgreSQL database. I use Ubuntu 12.10 and I am having some trouble creating a local DB.
First I use the if address I ...
1
vote
0answers
14 views
Postgres ODBC driver versions
On the Postgres ODBC driver page the name for each file is of the form:
psqlodbc_09_01_0100-x64.zip
psqlodbc_09_01_0100.zip
psqlodbc_09_01_0100-1.zip
psqlodbc_09_01_0200-x64.zip
...
0
votes
0answers
20 views
Cannot run pgAdmin from the terminal: No such file libwx_gtk2u
(Probably irrelevant) I'm using Puppet to setup/manage a class of computers that are equipped with PostgreSQL and PostGIS, and this implies that each computer goes through an unattended install:
...
1
vote
1answer
21 views
pgAdmin to display multiple result sets
With MS SQL Query Browser I can run multiple queries at the same time and each result set will display in it's own window.
Does PostgreSQL/pgAdmin have this functionality? Plugin perhaps?
2
votes
1answer
24 views
To select from all tables inside the schema in PostgreSQL
Is it possible to select from all tables inside the schema?
I got all the table names from
select table_name from information_schema.tables
but I am unable to use it to do my query.
0
votes
1answer
14 views
Is it possible for heroku postgres follower database to follow non-heroku postgres master?
I am considering to move our site's database from our dedicated db server to heroku postgres. as we have a few gigs of data in the db and don't want to take it down for a long migration downtime it ...
1
vote
2answers
30 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 ...
1
vote
1answer
34 views
How much time will a vacuum/autovacuum operation take?
I manage a big (some hundreds of gigs) database containing tables with various roles, some of them holding millions of records. Some tables only receive large number of inserts and deletes, some other ...
1
vote
1answer
38 views
Should my Postgres backup server be as beefy (IO, processor, RAM) as my master?
I've set up a Postgres database on a server with 2 CPU cores, 4GB of RAM and an SSD volume (on top of RAID 10 of course). This is our (sort-of) "beefy" production database server (I can easily add ...
0
votes
1answer
29 views
postgresql backup and restore
I'm trying to backup the database I made in postgresql but it doesn't seem to work
root@localhost:/home/tests# sudo -s -u postgres
postgres@localhost:/home/tests$ psql
psql (8.4.17)
Type "help" for ...
1
vote
2answers
34 views
Forgotten PostgreSQL Windows password
This morning I’ve been trying to connect the Postgresql database on my Windows 7 professional desktop.
The default value is ‘postgres’, but sure enough I forgot what password I used when I originally ...
-1
votes
2answers
39 views
How to drop inheritance?
I am new to PostgreSQL. The situation I have is someone created a child table inherits from the parent table. And dropped the child table. But the parent table still has the "down arrow" sign on it.
...
0
votes
1answer
40 views
How to retrieve data from Postgresql index using java
I am writing an application for searching, using text search of Postgresql. I am a beginner in Database. I created a Gin index and i am trying to get data from it. My code is
import ...
1
vote
1answer
22 views
PostgreSQL LDAP authentication
We are setting up a PostgreSQL 9.1 database at work. There are no classified data in the database, but we want to know who is doing what. We are using LDAP authentification on the network, so we would ...
0
votes
0answers
26 views
Recovering Postgres database
OK. I'm in a bit of trouble.
I've got an Ubuntu, had Postgres 9.1 installed.
There was something wrong with it - I couldn't start it for some reason. Out of panic, I backed up ...
1
vote
1answer
18 views
Error: Could not read Block X of relation base/Y/Z
We have some serious issues with our PostgreSQL-Server (Version 8.4). Our webapplication uses jdbc to connect to the PostgreSQL Server. Suddenly our webapplication cant connect to the PostgreSQL ...
1
vote
1answer
38 views
PostgreSQL: How can I setup Master-Slave replication with DML changes in Slave
I have a master database (PostgreSQL 9.0) and I need to setup a streaming replication on a slave. Slave db can read/write and make schema level changes too which shouldn't write back to master. Can ...
1
vote
1answer
21 views
pg_ctl start gives FATAL: role does not exist
On my system, whoami returns Dan. I run initdb with the --username=PgUser argument. Then as OS user Dan I run pg_ctl start on the newly-initialized cluster, and it gives this output:
LOG: database ...
1
vote
0answers
42 views
Postgres books for a Sql Server DBA [closed]
I have a team of Sql Server DBAs and Architects. One of our newer teams is building a product exclusively on Postgres. Now, I need to make sure that we have the knowledge base to support this project. ...
1
vote
1answer
44 views
Best practice for storing record metadata
What is the best practice for storing metadata of individual records in a database?
I need to store common meta data such as creation time and time of last update for many tables in my database. I ...
1
vote
2answers
44 views
Prune unused joins
I have expected that selecting from a view would not join the tables from which I don't query any values, but it doesn't seem to be the case.
I have a bunch of tables with the following structure:
...
5
votes
1answer
65 views
PostgreSQL “freeze”/“unfreeze” command equivalents
In Derby (an embedded database written in Java which is mostly used for testing or prototyping) there are "freeze" and "unfreeze" commands which can be used during an online backup. "Freeze" simply ...
0
votes
1answer
44 views
How to create fault tolerant databases? [closed]
I have a local application running on a LAN. Sometimes a database gets shutdown. In such a scenario how can I keep the application working? Can I have two concurrent databases so that one picks up the ...
0
votes
2answers
29 views
Mirrored tables on PostgreSQL
I have some values under "account" and I need to have the same values under "invoice", so, I'm trying to find a way to symlink my tables, so every time one gets updated, the another have the new value ...
0
votes
0answers
19 views
PostgresPlus advanced server replication testing issue
I made the replication on my Windows Server 2003 system as master DB and another XP system for slave DB. I just made the configuration, but I don't know how to check the replication of database.
I ...
3
votes
2answers
36 views
PostgreSQL: Executing DDL on every schema
I've a multi-tenant DB setup, and need to add some columns. I'm using schemas (and search_path) to partition my users, so I'm looking for a ubiquitous way to apply a DDL-schema change to all my ...
2
votes
2answers
16 views
Postgres Problems with Phusion Deployment (Rails)
FATAL: Ident authentication failed for user "test-postgres"
So I have a postgres server hosting a side of my database access for my Rails application and I have a database for production set up and ...
2
votes
0answers
39 views
Remove Mac OSX Lion pre-installation of PostgreSQL
I'm running Lion 10.7.5, and I'm trying to install Postgresql 9.2.4 for use with Django. I have hit countless roadblocks and errors, so I would like to start with a totally clean slate.
I did a brew ...
1
vote
2answers
63 views
Having a PostgreSQL database exposed to the internet
I've seen on DBA and other sites that exposing a database to the Internet is a particularly bad idea, but I noticed that PostgreSQL has SSL-certificate-only authentication. Does this make it any safer ...
0
votes
2answers
30 views
finding the path to start postgres
On my local machine, when I want to start the postgres server (postgres was installed via Homebrew), I do this
pg_ctl -D /usr/local/var/postgres -l logfile start
I just installed postgres on a ...
2
votes
1answer
28 views
Restoring SQL_ASCII dumps to a UTF8-encoded database
I've got a Postgres 8.4 environment where the encoding on all our databases is set to SQL_ASCII - We're finally migrating to Postgres 9.2, and I would like to migrate everything over to UTF8 encoding. ...
0
votes
1answer
21 views
Need a log based replication / CDC solution to publish postgres to oracle subscribers
We have a moderately large postgres 9.1 db that is currently 3TB and will likely grow much larger over the next couple of years. we need a reliable and fast solution for moving this data into either ...
1
vote
2answers
47 views
Troubleshooting high CPU usage from postgres and postmaster services?
I'm using an open source (RHEL 6.2) based machine running SIEM software. When I run the top command, I see postgres and postmaster both with 96% CPU usage. Is there a way to pin-point or see what ...
0
votes
3answers
36 views
How to “analyze” a SQL query?
I'm not sure if I used the right term in my question.
I am creating a prototype, which allows users to type in a raw SQL query, which will query the backend DB. I want to also make sure that users ...
0
votes
1answer
19 views
looking for a postgresql load emulation client
Is there any load emulation client for postgresql like mysqlslap? And is there any good monitoring tool for postgresql database server?
Thanks
0
votes
2answers
33 views
pg_dump 9.2.x command does not work with pg_dump 9.2.3
This is how i used to create all the time backups of my databases with PostgreSQL 9.2.x:
pg_dump -Fc -Z 6 -U postgres mydatabase > 2013-xx-xx_xxxxx.db
However on a machine where PostgreSQL with ...
1
vote
1answer
36 views
How to run recurring tasks on a Postgresql database without a cron-like tool?
I would like to call a stored procedure on a regular basis. On Oracle, I would create a job for this. I have found that Postgresql can mimic this well by using an external tool (cron etc) and PgAgent.
...
1
vote
1answer
24 views
Why does `pg_lsclusters` not list my Postgres cluster?
I apt-get installed Postgres 9.2.4 (using PPA).
I used pg_dropcluster --stop 9.2 main to remove the default database cluster, because I intended on creating a new cluster on a separate SSD volume (a ...
0
votes
1answer
26 views
Keeping version history of functions in PostgreSQL
For many of my tables, I've added auditing triggers (based on this wiki page). It works very well and has helped me several times figure out who changed what in the system. We have a Python/Django ...
2
votes
1answer
37 views
Force View's query plan to update?
I have a View whose query plan appears to be cached, is there a way to force the View's plan to be recalculated on each access?
2
votes
2answers
46 views
Postgresql constrains on FK
I am trying to design a (part of a) database which has to accomplish the following:
There is a students table, containing a bunch of students.
There are educations in the database.
Each student can ...
0
votes
1answer
52 views
Need an idea for a complex SQL question
I have had my cup of coffee, but cannot come up with a good solution for the following problem - so I am here to pick your brain. ;-)
Here is what I am trying to accomplish (for PostgreSQL):
Got a ...
0
votes
0answers
49 views
Waiting for response from Postgres server
I have a problem when query from application (Java) to PostgreSQL.
Here my query list (in 1 session user):
select count (id) from tb_a;
select count (id) from tb_a;
select nextval ('cssq_01');
select ...
0
votes
0answers
35 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
58 views
How to import a text file with '|' delimited data to PostgreSQL database? [closed]
I have a text file with | delimited data that I want to import to a table in PostgreSQL database. PgAdminIII only exports CSV files. I converted the file to a CSV file using MS excel but still was ...
2
votes
1answer
69 views
How to avoid large joins when determining which rows a user is authorized for?
Typical wep app situation: you have logged in users querying for resources exposed through an API. As a hypothetical example, company administrators quering for their employees' time sheets:
company ...
