Tagged Questions
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 itself in standards compliance and it boasts sophisticated features such as ACID, MVCC among many others.
1
vote
2answers
3 views
WAL Database log on separate disk good idea RAID10?
I have a RAID10-Server and have Postgres writing the log(pg_xlog a.k.a WAL) onto the same RAID10-Array.
I use the WAL in sync-mode with a big buffer and do alot of bulk inserts and updates, so that ...
2
votes
1answer
16 views
Postgresql 9.1 replication delay
I just set up a PostgreSQL 9.1.2 database server on debian squeeze.
I configured a standby server (hot standby) on a second identical server (squeeze, PG 9.1.2).
On the master I set these parameters ...
1
vote
1answer
45 views
Automating failover in Postgresql 9.1
How does one setup two identical servers for automatic failover in postgresql 9.1.
OS
Centos 5
Postgresql 9.1 compiled from source
The postgres user account exists on both machines and has a ssh ...
1
vote
1answer
37 views
Database as a service (DbaaS) over dimensions--performance, scalability, & reliability?
MySql Database as a service:
Amazon
Xeround
Another eg. PostgreSQL Database-as-a-Service.
You can get the list of similar products here.
Does anyone have details on their performance, ...
2
votes
2answers
32 views
postgresql view with max min with id
I have the following table:
CREATE TABLE trans (
id SERIAL PRIMARY KEY,
trans_date date,
trans_time time
);
I want to have the following view
CREATE OR REPLACE VIEW daily_trans ...
4
votes
2answers
73 views
PostgreSQL multi-column unique constraint and NULL values
I have a table like the following:
create table my_table (
id int8 not null,
id_A int8 not null,
id_B int8 not null,
id_C int8 null,
constraint pk_my_table primary key (id),
constraint ...
5
votes
2answers
555 views
Trigger: move deleted rows to archive table
I have a small (~10 rows) table called restrictions in my PostgreSQL database, where values are deleted and inserted on a daily basis.
I would like to have a table called restrictions_deleted, where ...
15
votes
1answer
709 views
Is there a good way to run a trigger for each record in a postgres table?
I have a system where I can't control the design of some tables (replicated via Slony-I), and so I have a series of what we refer to as 'shadow tables', where I extract some information out of the ...
5
votes
3answers
155 views
PostgreSQL Stored Procedure Performance
Coming from a MySQL background, where stored procedure performance (older article) and usability are questionable, I am evaluating PostgreSQL for a new product for my company.
One of the things I ...
1
vote
0answers
12 views
Using PL/PerlU with a non system perl lib
psql -1f check_email.pl.sql ccushing postgres
SET
psql:check_email.pl.sql:7: ERROR: Can't locate Email/Valid.pm in @INC (@INC contains: /usr/lib/perl5/site_perl /usr/share/perl5/site_perl ...
5
votes
5answers
677 views
What are the differences between “Stored Procedures” and “Stored Functions”?
So a comment from this question mentions, that there is a slight difference in "Stored Procedrues" and "Stored Funtions" in PostgreSQL.
The comment links to a wikipedia article but some of this don't ...
7
votes
1answer
103 views
Generate an exception with a Context
When PostgreSQL throws an exception, there is a line "CONTEXT" like:
ERROR: INSERT has more target COLUMNS than expressions
LINE 3: ...
...
1
vote
1answer
264 views
Postgres plpgsql - Using a variable inside of a dynamic create statement
Using Postgres pl/pgsql, I'm attempting to create a table using a dynamic EXECUTE command, such as:
...
DECLARE
tblVar varchar := "myTable";
BEGIN
EXECUTE 'CREATE TABLE $1 (
foo ...
2
votes
2answers
156 views
Plpgsql seems to be deleting and inserting instead of updating - Why?
I am using postgreSQL 7.4.
I have a large table , call it table_a:
key1 INT NOT NULL,
key2 INT NOT NULL,
data INT NOT NULL,
itstamp INT NOT NULL DEFAULT (date_part('EPOCH'::text, ...
1
vote
1answer
90 views
PostgreSQL archive_command on Windows
What is the best method for WAL log transfer on Windows?
Both servers are Windows Server 2008, PostgreSQL 9.0 64bit.
I have tried to use free rsync/rsyncd solution called DeltaCopy, but permissions ...
