| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | On 09/04/2012 06:04 PM, Mathias Breuninger wrote:
That isn't a supported configuration. The standby needs to be the same
architecture as the master...
Craig Ringer
|
09-04-2012 04:44 PM
Craig Ringer  | 0 | 64 |
| | | Hi all;
I've fired up 2 CentOS 6.2 VM's via vmware fusion 5 (on a mac).
I disables selinux on both, and installed postgres 8.4.13 on both VM's
I...
CS DBA
|
09-04-2012 03:17 PM
Anderson Lunz | 6 | 72 |
| | | I'm implementing replica servers which will use a trigger file to promote
from hot standby to full read/write. I've configured streaming...
David Morton
|
09-03-2012 05:01 PM
David Morton | 0 | 49 |
| | | On Wed, Aug 29, 2012 at 10:17 PM, Craig Ringer <ringerc (AT) ringerc (DOT) id.au>wrote:
Hello.
Thanks for the suggestions.
The Postgres log, with...
Gary Webster
|
09-03-2012 04:47 PM
Gary Webster | 1 | 55 |
| | | Forwarding to the list, since the first one did not go through.
-------- Forwarded Message --------
--
Devrim GÃœNDÃœZ
Principal Systems Engineer @...
Devrim GÜNDÜZ
|
09-01-2012 09:54 AM
Devrim GÜNDÜZ | 0 | 66 |
| | | amacvar <kahitarich-postgresForum (AT) yahoo (DOT) com> writes:
Interesting. The most plausible explanation I can see for this stack
trace is that...
Tom Lane
|
08-31-2012 02:53 PM
Tom Lane | 0 | 71 |
| | | In addition here is a backtrace of the process while it hung again today:
(thanks to our SA Eric)
#0 0x000000396c8d4627 in semop () from...
amacvar
|
08-31-2012 01:21 PM
amacvar | 0 | 46 |
| | | Hi,
I'm relatively new to Pg.
Question:
What could have happened to cause the COPY to unlogged table to hang?
And what would the recreate of the...
amacvar
|
08-30-2012 02:16 PM
amacvar | 0 | 72 |
| | | Hello.
The subject says most of what I know at this point.
We are still not getting along with Apache Jackrabbit.
After a few hours of using...
Gary Webster
|
08-29-2012 02:37 PM
Gary Webster | 0 | 62 |
| | | Hi,
On Sat, 2012-08-18 at 17:31 -0700, Jonathan Pool wrote:
Ok, I think I finally managed to find a solution for this. It is on the
testing phase...
Devrim GÜNDÜZ
|
08-28-2012 10:07 AM
Devrim GÜNDÜZ | 0 | 82 |
| | | btw, why the mail server rejected me many times? is it marked as spam?
-------- 原始消息 -------- 主题: ...
Rural Hunter
|
08-27-2012 11:42 PM
Rural Hunter | 0 | 74 |
| | | Hi there,
I am setting up a 2 node database cluster (Master/standby) on pgsql 9.1
and it looks to me that drdb option could be easier to maintain &...
Amador Alvarez
|
08-27-2012 02:12 PM
Amador Alvarez | 0 | 61 |
| | | I did my recharge on http://www.freecharge.in and got coupons of McDonald's,Cafe Coffee day, Baskin Robbin's, Domino's and many more. ...
rajatsangal1@gmail.com
|
08-25-2012 09:43 AM
rajatsangal1@gmail.com | 0 | 68 |
| | | CS DBA <cs_dba (AT) consistentstate (DOT) com> wrote:
That problem has nothing to do with PostgreSQL; you might have
better luck on a list related...
Kevin Grittner
|
08-24-2012 09:08 AM
Kevin Grittner | 0 | 66 |
| | | I've installed the odbc_fdw extension and I've got a DB2 ODBC driver installed. When I try the instructions...
James Foreman
|
08-24-2012 05:07 AM
James Foreman | 0 | 90 |
| | | I've got a fairly large table (186 million rows) that is moderately busy ( a few inserts per second at most) that I am trying to create a trigger on...
Greg Williamson
|
08-22-2012 08:45 PM
Tom Lane | 1 | 62 |
| | | "Saravanakumar Ramasamy" <rsk (AT) zoniac (DOT) com> wrote:
This was also posted on...
Kevin Grittner
|
08-20-2012 11:08 AM
Kevin Grittner | 0 | 95 |
| | | I am trying to follow the instructions on http://www.postgresql.org/download/linux/redhat/ for installing the PostgreSQL Yum Repository (on RHEL...
Jonathan Pool
|
08-19-2012 04:07 AM
Devrim GÜNDÜZ | 3 | 72 |
| | | Steve Crawford reported in September 2011 at
http://archives.postgresql.org/pgsql-admin/2011-09/msg00101.php
on "a packaging/library issue that...
Jonathan Pool
|
08-18-2012 07:31 PM
Jonathan Pool | 0 | 77 |
| | | Greetings,
I have a Mac Mini Server which I recently upgraded to Mountain Lion and then again with the optional Server.app i.e. OS X Server. ...
Eric Lemings
|
08-17-2012 02:21 PM
Joel Hedden | 1 | 64 |
| | | Hi All.
Now I am using postgres 9.1.3 version . Before I am used 8.2.22 after I
upgraded 9.1.3. Upgraded was successfully completed.
In Postgres...
Saravanakumar Ramasamy
|
08-17-2012 03:11 AM
Saravanakumar Ramasamy | 0 | 74 |
| | | Hi pg gurus,
I'm very new into postgres, and I need some help on handling large xml
files(20k lines or 1MB size) within the postgres database. Today...
Raju Angani
|
08-16-2012 01:25 AM
Raju Angani | 0 | 76 |
| | | I am consistently running into an "out of memory" error when using pg_dump.The error occurs after the step "saving database definition". This error...
Joe Tennant
|
08-14-2012 08:08 AM
Joe Tennant | 0 | 60 |
| | | Thanks for the help (server not running). The server is running and
accepting connections, but when I attempt a tcp/ip connection I get the
message:...
Richard Harper
|
08-13-2012 12:29 PM
Scott Marlowe | 4 | 95 |
| | | Since I upgraded to 9.1, the server has not been starting. psql works, and
pg_ctl status indicates that no server is connected.
If I run the...
Richard Harper
|
08-12-2012 08:40 AM
Lou Picciano | 3 | 74 |
| | | Hi experts,
I have a program running like a daemon, which analyze data and write to postgresql 9.1 on centos 5.8. There is only one connection...
Haifeng Liu
|
08-11-2012 06:26 AM
Craig James | 2 | 78 |
| | | hello admin,
I am using Postgresql for my application development, which is very robust
and secure to use.
For some interlink application purpose ,...
karthi keyan
|
08-10-2012 12:19 AM
Craig Ringer | 3 | 72 |
| | | On 08/10/2012 10:06 AM, Tom Lane wrote:
select * from pg_stat_activity
where current_query = '<IDLE> in transaction'
AND query_start <...
Craig Ringer
|
08-10-2012 12:08 AM
Craig Ringer | 1 | 69 |
| | | We have a small database (few hundred megs of data, lass than half that in indexes) that suffers from index bloat. Currently we handle this with an...
Greg Williamson
|
08-09-2012 11:20 PM
Tom Lane | 2 | 65 |
| | | Craig Ringer <ringerc (AT) ringerc (DOT) id.au> wrote:
I see that we currently have five links to wiki.postgresql.org in
release notes and four more...
Kevin Grittner
|
08-09-2012 09:22 AM
Kevin Grittner | 0 | 75 |
| | | Hello,
We are running PostgreSQL version 9.1.1 with 32GB of RAM, 32GB of SWAP and
during high load we could reach (swap + RAM) memory limit. In this...
Radovan Jablonovsky
|
08-09-2012 09:09 AM
Kevin Grittner | 9 | 81 |
| | | Hello,
I am trying to authenticate PostgreSQL 9.0 login roles against LDAP/Active
directory (AD). PostgreSQL 9.0 is installed on a Windows 2008 R2...
Michael O'Donnell
|
08-09-2012 08:12 AM
Smith, Hazel | 2 | 80 |
| | | Hello,
I am doing table partitioning, all is ok except that after executing 'insert' sql statement I can't get affected rows, it always be 0. After...
haifeng liu
|
08-09-2012 07:32 AM
Haifeng Liu | 1 | 67 |
| | | On Mon, Aug 6, 2012 at 1:14 PM, haifeng liu <haifeng.813 (AT) gmail (DOT) com> wrote:
It is usually not necessary to check it separately because if...
Sergey Konoplev
|
08-09-2012 06:11 AM
Sergey Konoplev | 1 | 91 |
| | | Hi.
I'm trying to work out failover and disaster recovery procedures for a
cluster of three servers. Streaming replication is being used with a...
Stuart Bishop
|
08-09-2012 05:25 AM
Sergey Konoplev | 1 | 73 |
| | | Hello,
I've recently come across the task of setting up a PostgreSQL 9.1 standby server that is N hours behind the master, i.e. only transactions...
Alexey Klyukin
|
08-08-2012 12:34 PM
Amador Alvarez | 3 | 75 |
| | | Hi All,
I have a pretty strange issue that I'm looking for ideas on.
I'm using Postgres Plus Advanced Server 9.1, but I believe this problem...
Terry Schmitt
|
08-07-2012 09:38 PM
Craig Ringer | 5 | 68 |
| | | I have a lot (maybe 1 every 10 seconds) of this error WARNING: pgstat wait
timeout
Also this
ERROR: canceling autovacuum task
Anibal David Acosta
|
08-06-2012 08:49 AM
Anibal David Acosta | 5 | 89 |
| | | On 08/06/2012 06:50 PM, Haifeng Liu wrote:
directly into the target partition, thus bypassing the trigger.
It's one of those things on the...
Craig Ringer
|
08-06-2012 08:14 AM
Craig Ringer | 0 | 77 |
| | | Hello,
I am doing table partitioning, all is ok except that after executing 'insert' sql statement I can't get affected rows, it always be 0. After...
Haifeng Liu
|
08-06-2012 05:50 AM
Haifeng Liu | 0 | 70 |
| | | Ko II
FCC
--
nw
--
Sent via pgsql-admin mailing list (pgsql-admin (AT) postgresql (DOT) org)
To make changes to your...
Nathan Wagner
|
08-04-2012 03:32 PM
Nathan Wagner | 0 | 72 |
| | | Alanoly Andrews <alanolya (AT) invera (DOT) com> writes:
We had a recent report of strange server-side behavior on AIX that went
away after...
Tom Lane
|
08-03-2012 03:01 PM
Tom Lane | 1 | 83 |
| | | select abbrev,utc_offset,count(*) from pg_timezone_names
where abbrev='EST'
group by abbrev,utc_offset
There are 12 times zones with 'EST' code,...
Laszlo Nagy
|
08-03-2012 01:25 PM
Laszlo Nagy | 13 | 111 |
| | | Hi Friends
Can u please help to write a function for the following scenario?
I have 3 table's user_roles, principals and roles.
Madhu.Lanka
|
08-03-2012 03:48 AM
Craig Ringer | 3 | 52 |
| | | Hello.
When running two 'separate' instances of Postgres on the same machine (diff
ports), do I also have two separate installs of the binaries...
Gary Webster
|
08-01-2012 02:59 PM
Joshua D. Drake | 1 | 41 |
| | | I have installed the following:
Maquina 1 Postgres 9.1 on Fedora 16 this is the Master
Maquina 2 Postgres 9.1 on Fedora 16 this is the...
Noe Gutierrez
|
08-01-2012 02:05 PM
Ascarabina | 2 | 44 |
| | | I am trying to setup readonly access to my user groups. I would like to grant select on a set of tables based on what Unix group they belong to. ...
Klink, John
|
07-31-2012 06:00 PM
Klink, John | 0 | 40 |
| | | All,
I am facing a weired issue in PG 9.0.3. Sometime via application UPDATES
are not changing data in the database but in postgres logs its also...
Amit Kumar
|
07-30-2012 11:52 AM
Craig James | 2 | 42 |
| | | Hello. I'm hoping someone has seen this before.
We are trying to use Postgres Plus v9.1.3 as the Persistence Manager in
Jackrabbit (Apache JCR)...
Gary Webster
|
07-27-2012 01:11 PM
Joshua D. Drake | 11 | 70 |
| | | On Mon, Jul 16, 2012 at 02:27:45PM +0930, Stephen Davies wrote:
OK, we already document the problems with postmaster.pid and rsync in
the backup...
Bruce Momjian
|
07-26-2012 01:30 PM
Bruce Momjian | 0 | 39 |
