On 4/08/2011 1:14 AM, Sumeet Jauhar wrote:
1 . There was a system crash due to a hardware failure .
A ) Isn’t Postgres database resilient enough to handle hardware system
failure ? or it sometime results in a corrupt index for its tables ? I
You should *always* be able to pull the plug out
On 9/08/2011 2:31 PM, Venkat Balaji wrote:
Hi Craig,
Thank you very much for your reply !
Here is my reply -
1. We are using RHEL with the below version
Linux version 2.6.18-194.26.1.el5
(mockbu...@x86-004.build.bos.redhat.com
mailto:mockbu...@x86-004.build.bos.redhat.com) (gcc version 4.1.2
On 9/08/2011 11:26 AM, iliya g wrote:
Hi guys,
I need some help discovering the processes that run on an instance. I
know that there are many processes running on one instance and they are
all called postges, but I was hoping you can help me find a way to
uniquely identify each one of them. I
On 2/08/2011 8:52 PM, RBharathi wrote:
Hi,
We plan to migrate data from Oracle 11g with characterset AL32UTF8 to a
Postgres db.
What is the euivalent charecterset to use in Postgress. We see only the UTF-8
option.
What's AL32UTF8 ? That's not a standard charset name or widely
recognised
On 9/08/2011 10:54 PM, c k wrote:
Normal python functions returning text etc. are working but when conatining
import sys
from uuid import getnode as get_mac
mac = get_mac()
return mac
fails. What will be the reason?
You still haven't supplied the error message you get when you run this.
In
I didn't get any error message. When calling the function from PGAdmin I get
error**.
When I try to re-execute it, it says 'no connection to the server'. When
checked the logs I found
2011-08-09 19:46:00 IST LOG: database system was interrupted; last known up
at 2011-08-09
Below is the output of ldd and gdb output with 'bt argument'
ldd output
[postgres@warehouse1 bin]$ ldd ./psql
libpq.so.5 = /opt/Postgres9.0.1/lib/libpq.so.5 (0x2b354bb1a000)
libedit.so.0 = /usr/lib64/libedit.so.0 (0x2b354bd49000)
libc.so.6 =
On Wed, Aug 10, 2011 at 1:23 AM, c k shreeseva.learn...@gmail.com wrote:
When I try to re-execute it, it says 'no connection to the server'. When
checked the logs I found
2011-08-09 19:46:00 IST LOG: database system was interrupted; last known up
at 2011-08-09 19:45:17 IST
2011-08-09
On 10/08/2011 3:43 PM, Venkat Balaji wrote:
libpq.so.5 = /opt/Postgres9.0.1/lib/libpq.so.5
OK, so it looks like it's runtime linking to the correct libpq, assuming
that the copy in /opt/Postgres9.0.1/ is the one for ... well .. 9.0.1 .
That was my first suspicion about what might
On 10/08/2011 4:07 PM, Mridul Mathew wrote:
Does PostgreSQL make a distinction within Unicode in a similar fashion?
No.
We have not tested our Oracle al32utf8 databases on PostgreSQL, but
while creating databases in PostgreSQL, we see UTF8 as an option, but
not al32.
al32utf8 is Oracle
What are the tentative release dates of 9.1 and 9.2 versions ?
Thanks.
On Wed, Aug 10, 2011 at 9:51 AM, A J s5...@yahoo.com wrote:
What are the tentative release dates of 9.1 and 9.2 versions ?
about 9.1:
http://archives.postgresql.org/message-id/19869.1312298...@sss.pgh.pa.us
9.2 is just starting its dev cicle, it will be released next year
--
Jaime Casanova
What is the suggested technique for cleaning up an archive location shared by
multiple standbys. Looks like pg_archivecleanup cannot be used as %r refers to
last restartpoint of only a single standby server.
Do I need to create a custom script that somehow determines the latest common
Also couple of additional related question:
2. Am I correct in my assumption that if for some reason archive is not cleaned
up and runs out of space, the WALs will accumulate in pg_xlog directory on the
primary. If pg_xlog was to then run out of space, Primary server will stop
accepting new
A J s5...@yahoo.com wrote:
What is the suggested technique for cleaning up an archive
location shared by multiple standbys. Looks like pg_archivecleanup
cannot be used as %r refers to last restartpoint of only a single
standby server. Do I need to create a custom script that somehow
A J s5...@yahoo.com wrote:
Also couple of additional related question:
2. Am I correct in my assumption that if for some reason archive
is not cleaned up and runs out of space, the WALs will accumulate
in pg_xlog directory on the primary. If pg_xlog was to then run
out of space, Primary
Couple of questions:
1. At what frequency is the archive_cleanup_command executed from the
recovery.conf file on the standby ?
2. If for some reason lets say a WAL file is missing from the archive directory
but the files after that are present. When the standby tries to restore the
missing WAL
2. If for some reason lets say a WAL file is missing from the archive
directory but the files after that are present. When the standby tries to
restore the missing WAL file, does it fail or it simply skips the missing
WAL file and goes to the next one.
I wont think it is possible if you are
A J s5...@yahoo.com writes:
Couple of questions: 1. At what frequency is the
archive_cleanup_command executed from the recovery.conf file on the
standby ?
Typically once per WAL file being processed.
2. If for some reason lets say a WAL file is missing from the
archive directory but the
On Wed, Aug 10, 2011 at 6:36 PM, A J s5...@yahoo.com wrote:
Couple of questions:
1. At what frequency is the archive_cleanup_command executed from the
recovery.conf file on the standby ?
2. If for some reason lets say a WAL file is missing from the archive
directory but the files after that
09.08.2011, 20:52, Kevin Grittner kevin.gritt...@wicourts.gov:
Vladimir Protasov eoran...@ya.ru wrote:
I want to completely disallow postgres to write WAL and turn it to
read-only instance WAL-compatible with another instance.
It is guarantied that there will be no write queries to the
Hello Craig,
Thanks for the response. You are correct in that the difference between
al32utf8 and utf8 is in better support for supplementary characters with
al32utf8.
If supplementary characters are inserted in a UTF8 database, they will be
treated as 2 separate undefined characters, occupying
Mridul Mathew mridulmat...@gmail.com wrote:
From: *Craig Ringer* ring...@ringerc.id.au
A 30-second Google search turned up this:
http://decipherinfosys.wordpress.com/2007/01/28/difference-between-utf8-and-al32utf8-character-sets-in-oracle/
If supplementary characters are inserted in a
Hi All;
We're getting the following error when we try to run initdb on an AIX box:
fgets failure: Error 0
The program postgres is needed by initdb but was not found in the same
directory as /opt/app/postgres/904/bin/initdb.
Check your installation.
We did this:
1) installed (via source)
CS DBA cs_...@consistentstate.com writes:
We're getting the following error when we try to run initdb on an AIX box:
fgets failure: Error 0
The program postgres is needed by initdb but was not found in the same
directory as /opt/app/postgres/904/bin/initdb.
Check your installation.
This
On 08/10/2011 01:16 PM, Tom Lane wrote:
CS DBAcs_...@consistentstate.com writes:
We're getting the following error when we try to run initdb on an AIX box:
fgets failure: Error 0
The program postgres is needed by initdb but was not found in the same
directory as
CS DBA cs_...@consistentstate.com writes:
On 08/10/2011 01:16 PM, Tom Lane wrote:
This means that initdb tried to execute postgres -V and didn't get any
output. What happens when you try that directly?
See below. One oddity, if I compile without the --with-openssl flag
(for the configure
On 08/10/2011 02:22 PM, Tom Lane wrote:
CS DBAcs_...@consistentstate.com writes:
On 08/10/2011 01:16 PM, Tom Lane wrote:
This means that initdb tried to execute postgres -V and didn't get any
output. What happens when you try that directly?
See below. One oddity, if I compile without the
Thanks Craig for your detailed explanation !
I had rebuilt the PG 9.0.1 with --enable-debug option.
As of now, i had downloaded a fresh package and re-installed. Its perfectly
working fine for me.
I will further try to debug this issue. Will let you know what i find.
Thanks
Nag
On Wed, Aug
29 matches
Mail list logo