Hello, im trying to get postgresql working on iPhone. Everything builds fine, ./configure no flags. I have all binaries compiled, but when...

Andrew Hoyt

Yesterday 03:50 AM
LeoTh3o

Hi list, is any aware of any comprehensive tutorials for setting up 2 postgres 9.1 databases in master-master configuration? What "add-ons" are...

Athanasios Kostopoulos

06-14-2013 03:08 AM
Athanasios Kostopoulos

I'm trying to decide if this task is best performed using triggers or some other method in the application itself. Basically I have two tables. When...

Some Developer

06-12-2013 11:15 AM
Some Developer

Hi, i'm in need of an advice and here is my situation. I've started putting stuff on paper, drawing my application and everything seems simple...

Toni Alfirević

06-11-2013 02:48 PM
Sergey Konoplev

Dear all, I'm trying to find a way to get the last sql error which happened on a database. Found that the last command could be retrieved...

Erik Ande

06-11-2013 09:04 AM
Bartosz Dmytrak

Hi , I am running PostgreSQL 8.3.6 on Red Hat Linux 5.5 and am getting empty log files in the pg_log directory. I am running the server with the...

Aditya Rastogi

06-08-2013 09:45 AM
Tom Lane

Hi! I have a question, which I'm certain may be a bug, but I thought I'd check with the community first before submitting it as one. I have the...

Christian Lawrence

06-03-2013 09:56 PM
Christian Lawrence

Hi, I´m using the copy command to generate a csv file, but the generation its extremely slow in a production server. In our test's server thiscopy...

Jalisson Mello

05-31-2013 03:40 PM
Merlin Moncure

Hi Amit, Yes, you're absolutely right. I was running the commands in psql rather than the shell. It wasn't obvious from the tutorial that I was...

Frank Moore

05-31-2013 02:59 PM
Frank Moore

It appears that you are running pg_restore inside psql. Have you tried running it in shell and not psql? -- Amit Langote -- Sent via pgsql-novice...

Amit Langote

05-30-2013 11:10 PM
Amit Langote

Hi, I've installed PostgreSQL 9.2 (client and server) on a local Windows desktop and can run pgAdmin to see the postgres database. However, now I'm...

Frank Moore

05-30-2013 03:40 PM
Frank Moore

We have some 'big' and some 'small' tablespaces that we what to monitor using pg_tablespace_size Now we know that we can use pg_size_pretty to tidy...

Birchall, Austen

05-29-2013 11:20 AM
Birchall, Austen

Un cordial saludo a la comunidad de Postresql. En la empresa donde laboro me he conseguido con una aplicación que esta trabajando originalmente en...

Jose Manuel Piña T.

05-28-2013 06:38 PM
Jose Manuel Piña T.

8.4.13 & PostGIS 2.0 on Red Hat 6 I want to do a offline backup of /var/lib/pgsql/data But whenever I do Pg_ctl stop I get

Birchall, Austen

05-23-2013 04:06 AM
Birchall, Austen

Hello. I have a web surveying system backed by PostgreSQL. A common use case is for internal staff to make a series of changes to some survey...

Michael Swierczek

05-20-2013 03:52 PM
Michael Swierczek

Sorry, once again. Hello, everyone My software environment is the following:

changhh

05-19-2013 10:51 PM
changhh

Hello, I'm using PostGreSQL on eComStation (nee OS/2). My system is generating enormous log files in a folder called pg_xlog. They are 16MB each...

jjurban

05-16-2013 07:53 PM
Amit Langote

Greetings, I'm struggling with a bit of SQL here and am looking for ideas on how to resolve it. Given the following query: Select ta.accountname,...

Chris Campbell

05-09-2013 08:56 PM
Jayadevan M

When minor releases and/or Security releases are made public are there any mechanisms in place for the automatically notifying the community that...

Birchall, Austen

05-08-2013 09:47 AM
Greg Sabino Mullane

Hello, I am currently attempting to work my way through the set of tutorials, posted by Koushik, on the subject of using Hibernate with PostgreSQL,...

David Alvarez

05-08-2013 12:57 AM
Simon Riggs

Hello, I am not sure if pgsql-novice is place for this but this sounds like a basic locking understanding question so here: While studying group...

Amit Langote

05-07-2013 12:06 AM
Amit Langote

It hit me today that a 1..* relationship can't be implemented just by a single foreign key constraint. I must have been sleeping very deeply not to...

Wolfgang Keller

05-02-2013 04:51 PM
David Johnston

Watch this video to learn to recover iPhone lost Contacts http://www.youtube.com/watch?feature=player_embedded&v=vP4O21X5scA -- View this message...

simonyanderson

04-26-2013 06:41 AM
i2013

Just as a permanent XID is allocate only when needed, is there any way to defer the acquisition of a snapshot till it is needed such that statements...

Daniel Wood

04-24-2013 11:50 PM
Tom Lane

I am learning postgresql, and I started on 4/21. *I downloaded the files, set everything up, found some tutorials online, and all was great. * The...

J. Jeffery kyzer

04-22-2013 02:39 PM
J. Jeffery kyzer

Hello and good day I am learning postgresql, and I started on 4/21. *I downloaded the files, set everything up, found some tutorials online, and all...

J. Jeffery kyzer

04-22-2013 02:24 PM
J. Jeffery kyzer

Hope this has not been just recently covered if so apologies. I'm after a simple way to upgrade from 8.4 to the latest version of postgres (my...

Richard Terry

04-19-2013 08:20 PM
Richard Terry

Hi, I've installed PostgreSQL 9.2.4, created a new database, created 1 new role and 1 table called t_test. When I connect using psql with my new...

Diogo Martinez

04-19-2013 02:27 PM
Tom Lane

Hi, using postgres ( super user) , I create a database for user1 (normal role) 1. create database db1 owner user1; 2. \l postgres=# \l List of...

kobolds

04-19-2013 06:53 AM
kobolds

As you already know, one way to upgrade a PostgreSQL DB from one version to another is to perform a pg_dump/pg_restore using the commands of the...

JORGE MALDONADO

04-17-2013 04:58 PM
JORGE MALDONADO

As you already know, one way to upgrade a PostgreSQL DB from one version to another is to perform a pg_dump/pg_restore using the commands of the...

JORGE MALDONADO

04-17-2013 04:58 PM
JORGE MALDONADO

8.4.13 on Red Hat 6 I am doing a backup/restore test of a 'quite large' database I ran the following backup pg_dump -Fc testdb -U postgres >...

Birchall, Austen

04-16-2013 10:56 AM
Birchall, Austen

8.4.13 on Red Hat 6 I am doing a backup/restore test of a 'quite large' database I ran the following backup pg_dump -Fc testdb -U postgres >...

Birchall, Austen

04-16-2013 09:24 AM
Birchall, Austen

Hello, I am relatively new to SQL databases in general, and very new to postgresql, so please be gentle. My question has to do with how to properly...

Tanstaafl

04-15-2013 04:36 PM
Tanstaafl

Hi, I playing around with view privileges , - I create 2 users (user1 and user2) - drop schema public; - create table sh1.tb1 (emp_no integer ,...

kobolds

04-11-2013 06:02 PM
Kevin Grittner

Call me stupid if you must, but I've tried both tcp_keepalive_xxx parameters and PQcancel() to abort a query to a remote server to which I've lost...

Steve Rosenberry

04-10-2013 08:37 AM
Steve Rosenberry

On 9 April 2013 16:48, Steve Rosenberry <smrosenberry (AT) electronicsolutionsco (DOT) com> wrote: If I understand it correctly PQgetCancel operates...

Andrej

04-09-2013 05:12 PM
Andrej

I have a doubt about replication, hopefully they can help me. I have several databases all in version 9.2, geographically distant, as in the example...

Franklin Haut

04-06-2013 09:05 AM
Kevin Grittner

We will be using a PostgreSQL database in a 64-bit Windows Server 2008 OS. Should I install a 64-bit version of PostgreSQL too? Is there a place...

JORGE MALDONADO

04-03-2013 11:34 PM
Pandu Poluan

I'm new to PostgreSQL and this is my first post to this mailing-list. Hopefully it's ok. I've searched through the archives (and Google), without...

Henrik Aagaard Sørensen

04-02-2013 05:26 PM
Kevin Grittner

Hi, all. Running PostgreSQL 9.1.8 on Xubuntu 12.04, installed from the repos. From the shell, I have executed: createlang plperl...

Thangalin

04-02-2013 03:50 PM
Thangalin

Hi , I have question about.pgpass . I have been playing around with postgresql privileges setting . I created a role user1 (not superuser) for the...

kobolds

04-02-2013 07:48 AM
Bastiaan Olij

dinesh <dinesh (AT) vssod (DOT) com> writes: Well, it's not a bug. RETURNING is defined as returning one row per row inserted/updated/deleted, so...

Tom Lane

03-25-2013 02:20 AM
dinesh

The pg UPDATE manpage states that... The syntax of the RETURNING list is identical to that of the output list of...

dinesh

03-24-2013 02:15 PM
dinesh

Hi All I have a table that contains arrays of integers. These integers are code names for quantities. Each quantity (hence integer) has also an...

Mehmet Yunt

03-24-2013 08:19 AM
myunt

Hello, I am trying to create a UDF in C that returns multiple rows. I followed the examples in the contrib directory which does the following: 1 ...

Terry Chong

03-19-2013 02:05 PM
Tom Lane

Hi I created the following role postgres=# create role sde LOGIN PASSWORD 'passwd' SUPERUSER NOINHERIT CREATEDB; CREATE ROLE postgres=# However...

Birchall, Austen

03-19-2013 07:57 AM
Tom Lane

I have given up hope to recover the lost data and have activated: zero_damaged_pages = on in postgresql.conf and restarted postgres. See:...

Marcel Ruff

03-18-2013 12:02 PM
Marcel Ruff

Hi, I use psql (PostgreSQL) 9.2.2 postgresql-9.2-1002.jdbc4.jar java version "1.7.0_17" 64-Bit Server VM on Linux 3.4.28-2.20-default

Marcel Ruff

03-18-2013 05:11 AM
Marcel Ruff

Hi , I'm new in postgresql but have been using mysql for years , I planning to migrate to postgresql, I currently playing around with the schema...

kobolds

03-14-2013 02:21 PM
Prashanth Goriparthi