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 19:45:1
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 => /lib64
On Wed, Aug 10, 2011 at 1:23 AM, c k 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 19:46:00 IST LOG: database s
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 b
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 spe
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 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 www.2ndQ
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
restartpoi
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 writ
A J 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
> determines the la
A J 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 server will st
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 f
>
> 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 y
A J 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 files after t
On Wed, Aug 10, 2011 at 6:36 PM, A J 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 are present
09.08.2011, 20:52, "Kevin Grittner" :
> Vladimir Protasov 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
>> server, but I need to be sure
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 6
Mridul Mathew wrote:
> From: *Craig Ringer*
>> 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 UTF8 database, they
> will be treated 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 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 means that initdb tr
On 08/10/2011 01:16 PM, Tom Lane wrote:
CS DBA 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 installat
CS DBA 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 command) then it w
On 08/10/2011 02:22 PM, Tom Lane wrote:
CS DBA 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 t
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 10,
24 matches
Mail list logo