| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | PgAdmin doesn't retain the saved passwords when a connection to a server
fails.
I'd like to request that the saved passwords be kept, even in the...
Michael Shapiro
|
05-26-2012 02:38 PM
Michael Shapiro  | 0 | 2 |
| | | Hello everyone,
just wanted to introduce myself and ask a question ...
I am currently helping out a friend to set up a postgres database for
his...
matthias
|
05-25-2012 11:01 AM
Steve Crawford | 1 | 4 |
| | | I am seeing, what appears to me, strange behavior during PG_DUMP backups.
These pg_dump backups have been running for weeks with no issue, and run...
Adam Fuchs
|
05-24-2012 04:31 PM
Adam Fuchs | 0 | 1 |
 | | H,
after a few days, i'm seeing the following logs in a database (postgresql
8.3.15 on Windows)
running with rubyrep 1.2.0 for syncing a few table...
Vincent Dautremont
|
05-23-2012 04:46 PM
Vincent Dautremont | 10 | 12 |
| | | Hello,
I have a tomcat server with 7 applications connecting to PG 8.4. All apps
use connection pooling. Over the weekend the apps ran out of...
Daryl Stultz
|
05-19-2012 08:24 AM
Daryl Stultz | 4 | 28 |
| | | Dear Colleagues,
I found the answer to my own problem -- the root.crl (Certificate
revocation list) was malformed. When I deleted the root.crl files...
Robert Bruccoleri
|
05-18-2012 05:29 PM
Robert Bruccoleri | 0 | 13 |
| | | Hello,
Apologies in advance for asking here and not on the greenplum forum, but I'm asking here because I think the PG community understands pg...
Little, Douglas
|
05-18-2012 12:01 PM
Scott Marlowe | 1 | 18 |
| | | Hi all,
i have a question. I'd like to create a trigger function that "call" and
external application (es . C:\myprogram.exe) when a new row will be...
francescoboccacci@libero.it
|
05-17-2012 11:08 AM
Fabrzio de Royes Mello | 3 | 24 |
| | | yes, thanks. I would like to intall pl/python in windows. Where i can find this module?Thanks
Francesco
----Messaggio originale----
Da:...
francescoboccacci@libero.it
|
05-17-2012 09:53 AM
francescoboccacci@libero.it | 0 | 13 |
| | | I'm investigating a 'could not stat file' error that points to a file
"base/16384/52212305.1". All the data files I've ever seen have names that
are...
David Schnur
|
05-16-2012 01:56 PM
ktm@rice.edu | 1 | 17 |
| | | I am experiencing a little higher CPU load than I would like to see, and
was wondering if it has to do with the number of connections (although
many...
Benjamin Krajmalnik
|
05-14-2012 12:13 PM
ktm@rice.edu | 1 | 15 |
| | | Hi All,
I'm running into a weird issue with PostgreSQL 9.1.3 and PostGIS 2.0
when trying to dump a table - no matter what table I try to dump in...
Chander Ganesan
|
05-14-2012 08:52 AM
Elizandro Gallegos | 4 | 28 |
| | | On 05/02/2012 12:55 PM, Mitesh Shah wrote:
The problem is you are using an older version of pg_dump to dump a newer
database. That will not...
Adrian Klaver
|
05-11-2012 02:39 PM
Adrian Klaver | 0 | 17 |
| | | "Gnanakumar" <gnanam (AT) zoniac (DOT) com> wrote:
The main point of using a connection pooler is to funnel a large
number of client connection...
Kevin Grittner
|
05-10-2012 07:29 PM
Bruce Momjian | 3 | 18 |
| | | Hi Everybody,
I am testing the new features in 9.1 related to backups and restores.
I want to establish a workflow for doing a base backup, archiving...
Kasia Tuszynska
|
05-10-2012 07:11 PM
Kasia Tuszynska | 0 | 11 |
| | | Hi,
Our Production server has got 35 GB physical RAM size. Since the server
has lots of RAM, we want to really make use of it. We've already...
Gnanakumar
|
05-10-2012 03:32 AM
Gnanakumar | 6 | 22 |
| | | With PostGIS 2.0 if I load/install postgis using the command:
create extension postgis schema postgis;
And then use the command:
pg_dump -t...
Chander Ganesan
|
05-09-2012 12:41 PM
Tom Lane | 1 | 15 |
| | | Brian Ferhle <brianf (AT) consistentstate (DOT) com> wrote:
Given all the other settings, doubling
max_pred_locks_per_transaction would probably...
Kevin Grittner
|
05-08-2012 12:29 PM
Kevin Grittner | 0 | 16 |
| | | Hi all,
I've got a situation where I need to increase max_pred_locks_per_transaction value to allow the addition of a slony node to complete on...
Brian Ferhle
|
05-08-2012 11:55 AM
Brian Ferhle | 0 | 14 |
| | | I am currently using postgresql version 9.1.3
In the past, when I ran psql and needed useful information provided by commands like \h or \d, the...
Fred Parkinson
|
05-08-2012 10:11 AM
Kevin Grittner | 3 | 16 |
| | | Hi,
Recently, in our Production server, we found a "single query" being held up
in "<IDLE> in transaction" for more than 19 hours using the...
Gnanakumar
|
05-08-2012 01:24 AM
Thomas Markus | 9 | 25 |
| | | Hello,
I wonder whether extra measures are necessary to recover from a disk full error besides freeing enough disk space?
It seems that there are...
Jan-Peter Seifert
|
05-07-2012 12:09 PM
Kevin Grittner | 1 | 27 |
| | | I recently recompiled our Postgres extension functions and re-encountered a
problem that I thought was solved. When I call our function, the code...
Craig James
|
05-04-2012 11:57 AM
Craig James | 0 | 26 |
| | | Hi,
I'm trying to enable "ident" authentication on my Windows machine using PostgreSQL 9.1
However as soon as I add the following line to...
Thomas Kellerer
|
05-04-2012 08:50 AM
Thomas Kellerer | 4 | 16 |
| | | "Plugge, Joe R." <JRPlugge (AT) west (DOT) com> wrote:
The DELETE and UPDATE triggers need to be on the child tables. An
operation on a child...
Kevin Grittner
|
05-03-2012 12:54 PM
Kevin Grittner | 0 | 19 |
| | | Using postgres 9.0.7 on RHEL 5.4. I have a parent table that is partitioned by day. My inserts are working correctly and are being directed to the...
Plugge, Joe R.
|
05-03-2012 11:40 AM
Plugge, Joe R. | 0 | 20 |
| | | Dear admin,
I have successfully set up the stream replication M1--IP1, M2---IP2, my question is if the master is down, the slave will become read and...
sgm
|
05-03-2012 03:05 AM
sgm | 2 | 20 |
| | | There used to be a switch in pg_dump that would disable the version, you can
even see that's in the man page. However, it is not reccommended and the...
Robert Bernier
|
05-02-2012 05:27 PM
Robert Bernier | 0 | 15 |
| | | Mitesh Shah <mitesh.shah (AT) stripes39 (DOT) com> wrote:
This is not a bug. Use a version of pg_dump which is at least as
new as the server. The...
Kevin Grittner
|
05-02-2012 04:53 PM
Kevin Grittner | 0 | 17 |
| | | Hi,
I am trying to create a daily backup cron script but it fails with an error
as below:
Any pointers to resolve this will be greatly...
Mitesh Shah
|
05-02-2012 02:55 PM
Mitesh Shah | 0 | 13 |
| | | I've issued the following statement:
grant select on all tables in schema support to backup;
When I perform a pgdump of the support schema with the...
Tony Capobianco
|
05-02-2012 02:07 PM
Kevin Grittner | 1 | 16 |
| | | Hariraman Jayaraj <hariraman.ocp (AT) gmail (DOT) com> wrote:
It helps to know the exact version number and PostgreSQL
configuration...
Kevin Grittner
|
05-02-2012 12:26 PM
Kevin Grittner | 0 | 15 |
| | | Hi,
We are using postgres 8.3 in Open Suse 11 server.
Front end - Java, struts
Middle ware - Jboss
Backend - Postgres 8.3 DB.
Recently I am...
Hariraman Jayaraj
|
05-02-2012 02:05 AM
Hariraman Jayaraj | 0 | 18 |
| | | Hi all,
I'm asked to benchmark a PG-related product. I was wondering if there
is any "sort of standard" public dataset for such operations. The...
Bèrto ëd Sèra
|
05-01-2012 10:06 AM
Thomas Kellerer | 2 | 33 |
| | | On Wed, Apr 20, 2011 at 2:13 PM, rajibdk <rajib.deka (AT) siemens (DOT) com> wrote:
Please refer...
Simon Riggs
|
04-30-2012 06:54 PM
DM | 1 | 25 |
| | | All;
I just want to be sure that I'm not causing myself greif. I have a kvm
in the cloud that is supposed to have access to 32GB of ram. when I do...
Kevin Kempter
|
04-28-2012 07:13 PM
Fernando Hevia | 2 | 28 |
| | | Hi Everyone,
I am trying to get pg working on os x lion and getting some configuration errors. Wondering if anyone on this list faced these...
Andrew Barinov
|
04-28-2012 04:02 PM
Andrew Barinov | 3 | 23 |
| | | Hi all;
I've setup PostgreSQL to talk across servers thousand of times... not
sure what I'm doing wrong, maybe I'm just over-tired.
I have 2...
Kevin Kempter
|
04-27-2012 04:44 AM
Frank Lanitz | 5 | 24 |
| | | Hi folks,
Does anybody know if it is possible to create a PL which sends an http GET
request and retrieves its response ?
I am willing to use a REST...
Ricardo Bayley
|
04-25-2012 03:21 PM
Kevin Grittner | 1 | 23 |
| | | Hello, everyone. I want to throw a scenario out there to see what y'all think.
Soon, my cluster backups will be increasing in size inordinately....
Scott Whitney
|
04-25-2012 12:41 PM
amador alvarez | 3 | 23 |
| | | Hello,
after some fiddling i had success in making PostgreSQL 9.1 somewhat more
portable.
Some of our customers need to copy and run our application...
BGoebel
|
04-25-2012 05:35 AM
BGoebel | 0 | 18 |
| | | Hello,
We have some problems using pg_dump. We get the following error:
pg_dump: schema with OID 145167 does not exist
Paul Wouters
|
04-25-2012 02:02 AM
Lukasz Brodziak | 2 | 38 |
| | | Trying to call my function like so:
select myschema.myfunction(select myid from mytable);
myfunction has the signature: myfunction(integer)
myid...
Wells Oliver
|
04-23-2012 11:09 PM
Naoko Reeves | 1 | 37 |
| | | In FTS, how do I search for partial substrings that don't form a English word.
Example, in the text: 'one hundred thirty four'* I want to find...
A J
|
04-23-2012 01:53 PM
Jesper Krogh | 2 | 27 |
| | | http://tega-marketing.com/wp-content/plugins/extended-comment-options/life.php?entire186.png
--
Sent via pgsql-admin mailing list (pgsql-admin (AT)...
Greg Caulton
|
04-23-2012 11:05 AM
Greg Caulton | 0 | 20 |
| | | Is there a way to get the date that starts week 14, or 15 (etc)?
--
Wells Oliver
wellsoliver (AT) gmail (DOT) com
Wells Oliver
|
04-23-2012 02:39 AM
Albe Laurenz | 2 | 28 |
| | | Hi tehre,
in every database there is a file nammed pg_filenode.map
wich I suppose give the map of the real filenode while some command make
a...
F. BROUARD / SQLpro
|
04-22-2012 11:29 AM
Kevin Grittner | 1 | 34 |
| | | Hi,
We are trying to migrate from Postgres to Oracle, although our DB is
gigantic
but we started on Mar 14th 2012 & its still running with an...
ЇЯЅHAÐ
|
04-20-2012 06:48 PM
Thomas Kellerer | 4 | 46 |
| | | Hi folks,
I'm analyizing why our /var/lib/postgresql partition got a quick bump in
usage (from 32GB to 41GB) few days ago, even if, according to...
Alexander Fortin
|
04-20-2012 06:04 AM
Alexander Fortin | 9 | 44 |
| | | Hello,
I am using Postgres version 8.3.17 on one of my database server. I have
received a .sql dump file from my client. Which is supposed to...
Kshirsagar, Swanand
|
04-20-2012 04:06 AM
Albe Laurenz | 1 | 26 |
