Thank you for letting me know about pg_controldata. I have been playing around
with this tool.
I notice on my master server I have:
Latest checkpoint location: 1E3/F220
Prior checkpoint location:1E3/F120
Latest checkpoint's REDO location:1E3/F220
And on t
On 2011-02-07, at 11:27 AM, Edoardo Panfili wrote:
> On 07/02/11 18.55, Paul Ramsey wrote:
>> Well, maybe you could in-place upgrade if you left your PostGIS version
>> at the original and only upgraded the PostgreSQL part, but you aren't
>> doing that, you're also upgrading your PostGIS version.
On Tue, 08 Feb 2011 14:23:54 +0200, Devrim GUNDUZ wrote:
> In the next 2 days. There is an issue in the current RPM buildfarm that
> resulted in delay.
Thank you for your reply.
--
OTSUKA Kenji
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
--
Sent via pgsql-
On Tue, Feb 08, 2011 at 08:51:42PM -0600, Ogden wrote:
>
> On Feb 8, 2011, at 8:47 PM, Ray Stell wrote:
>
> >
> > pg_controldata command is helpful.
> >
> > Archiving wal not required, but you can roll it either way.
> >
> >
>
> That is my confusion - Archiving wal does not conflict in any
If the standby server cannot pull the WAL file from the master using
streaming replication, then it will attempt to pull it from the archive. If
the WAL segment isn't archived (for example because you aren't using
archiving), then your streaming replication is unrecoverable and you have to
take a
David Kerr writes:
> I'm getting the above error in one of my dev DBs.
Would you poke around in the system catalogs and find where the dangling
reference is located? Have you got any idea of how to reproduce this
failure from a standing start?
regards, tom lane
--
Sent
On Feb 8, 2011, at 8:47 PM, Ray Stell wrote:
>
> pg_controldata command is helpful.
>
> Archiving wal not required, but you can roll it either way.
>
>
That is my confusion - Archiving wal does not conflict in any way with
streaming replication? What if streaming replication lags behind (e
pg_controldata command is helpful.
Archiving wal not required, but you can roll it either way.
On Tue, Feb 08, 2011 at 04:46:51PM -0600, Ogden wrote:
> Hello all,
>
> I have set up PostgreSQL Streaming Replication and all seems to work fine
> when updating records as the records are inst
On Tue, Feb 8, 2011 at 8:30 PM, Andrew Dunstan wrote:
> Quite right, but the commitfest manager isn't meant to be a substitute for
> one. Bug fixes aren't subject to the same restrictions of feature changes.
Another option would be to add this here:
http://wiki.postgresql.org/wiki/PostgreSQL_9.1
On Mon, Jan 31, 2011 at 7:36 PM, Tom Lane wrote:
> Thom Brown writes:
> > Actually, those lower bound errors aren't related to generate_series,
> > but I'd still like to know why -2147483648::int4 is out of range.
>
> :: binds tighter than - (and everything else too). Write
> (-2147483648)::int
On Tuesday, February 08, 2011 2:44:51 pm Mike Christensen wrote:
> >> Here's the error:
> >>
> >> pg_dump: SQL command failed
> >> pg_dump: Error message from server: ERROR: permission denied for
> >> relation pantryitems
> >> pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHAR
On 02/08/2011 08:19 PM, Itagaki Takahiro wrote:
On Wed, Feb 9, 2011 at 10:17, Andrew Dunstan wrote:
Isn't this all really a bug fix that should be backpatched, rather than a
commitfest item?
Sure, but we don't have any bug trackers...
Quite right, but the commitfest manager isn't meant to
On Wed, Feb 9, 2011 at 10:17, Andrew Dunstan wrote:
> Isn't this all really a bug fix that should be backpatched, rather than a
> commitfest item?
Sure, but we don't have any bug trackers...
--
Itagaki Takahiro
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
On 02/07/2011 06:38 AM, Thom Brown wrote:
On 7 February 2011 09:04, Itagaki Takahiro wrote:
On Fri, Feb 4, 2011 at 21:32, Thom Brown wrote:
The issue is that generate_series will not return if the series hits
either the upper or lower boundary during increment, or goes beyond
it. The attac
Is there a way we can validate a postgers backup? (short of restoring it
somewhere)
Thanks!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
howdy all,
I'm getting the above error in one of my dev DBs.
I've read in the archives that to stop the error from happening I can just
delete entries in pg_type and pg_class, however there seemed to be some
community interest in doing some debugging.
(mentioned in this thread:
http://archiv
I actually posted a more detail posting on this issue but I have a lot of
extra information that jumbles things up.
More simply if you run any query of the form:
SELECT subquerycolumn
FROM (
SELECT subquerycolumn FROM table WHERE [condition] FOR UPDATE -- WHERE
is optional but obvi
Where can I find information about recovery_target_time or
recovery_target_xid. I have two servers db1 and db2,
WAL files are copied from db1 to db2. Database will colapse at 17:10 and
i wan't to recove base from 17:05, so where can I find info about
recovery_time.
Albert
--
Sent via p
On Dienstag, 8. Februar 2011, Carlos Mennens wrote:
> Why am I not prompted for a password when I connect from my laptop
> to the server?
check your pg_hba.conf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/m
Hello all,
I have set up PostgreSQL Streaming Replication and all seems to work fine when
updating records as the records are instantaneously updated on the slave,
however, I was wondering perhaps if someone can give me some verification that
what I am doing is alright or some more insight into
On 02/08/11 2:44 PM, Mike Christensen wrote:
Here's the error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for
relation pantryitems
pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE
MODE
Does the user need to be a superuser, or
>> Here's the error:
>>
>> pg_dump: SQL command failed
>> pg_dump: Error message from server: ERROR: permission denied for
>> relation pantryitems
>> pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE
>> MODE
>>
>> Does the user need to be a superuser, or is there some way to
On 8 February 2011 22:27, Michael wrote:
>
> On Tues., Feb 08, 2011, Thom Brown wrote:
>>On 8 February 2011 19:28, Andreas Kretschmer
>>wrote:
>>> Thom Brown wrote:
On 8 February 2011 18:45, Andreas Kretschmer
wrote:
> Michael wrote:
>> I'm trying to view text data stored b
Today on a new PostgreSQL 9.0.3 server I created a new user:
CREATE ROLE carlos LOGIN CREATEDB CREATEROLE;
CREATE ROLE
I then set a password and comment on the user:
ALTER ROLE carlos WITH PASSWORD 'letmein';
ALTER ROLE
COMMENT ON ROLE carlos IS 'Database Administrator';
COMMENT
So I now try t
On Tues., Feb 08, 2011, Thom Brown wrote:
>On 8 February 2011 19:28, Andreas Kretschmer wrote:
>> Thom Brown wrote:
>>> On 8 February 2011 18:45, Andreas Kretschmer
>>> wrote:
Michael wrote:
> I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest)
> as BLOB and Postgr
Szymon Guz, 08.02.2011 09:30:
Hi, is there any noticeable difference between a cluster with many
databases and a database with many schemas?
I've got a quite huge database on Oracle with about 400 logically
disjoint schemas. I could import that into PostgreSQL as many
different databases, or as
I don't use pl/perl, but I've seen a very similar "could not load
library" error with pl/python on Windows, even though the dll named
was present. Windows gives very bad error messages when it fails to
dynamically link. You could use something like dependency walker,
which is probably a pain. I thi
Thom Brown wrote:
> On 8 February 2011 19:28, Andreas Kretschmer
> wrote:
> > Thom Brown wrote:
> >
> >> On 8 February 2011 18:45, Andreas Kretschmer
> >> wrote:
> >> > Michael wrote:
> >> >
> >> >>
> >> >> Hello list,
> >> >>
> >> >> I'm trying to view text data stored by OpenSIPS 1.6.4 (t
On 02/08/2011 10:57 AM, Mike Christensen wrote:
Here's the error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for
relation pantryitems
pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE
Does the user need to be a superuser,
2011/2/8, Mike Christensen :
> Here's the error:
>
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: permission denied for
> relation pantryitems
> pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE
>
> Does the user need to be a superuser, or is
>I see nothing tricky in your CRUDdy procedures. I would think porting
>the sql-generator would be pretty straight forward. "Except for the
>names and a few other changes, the story's the same one.": read the
>system catalogues and generate your procs-cum-functions. Your jdbc
>interactions should
Il 08/02/2011 10.42, Pavel Stehule ha scritto:
> Hi
>
> 2011/2/8 Thomas Markus :
>> hi,
>>
>> i would prefer many schemas. advantages:
>> - one backup/restore for all (or selective)
But this also means if one crashes all crash.
And lack of flexibility in deployments.
It heavily depends in what
On 8 February 2011 19:28, Andreas Kretschmer wrote:
> Thom Brown wrote:
>
>> On 8 February 2011 18:45, Andreas Kretschmer
>> wrote:
>> > Michael wrote:
>> >
>> >>
>> >> Hello list,
>> >>
>> >> I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest)
>> >> as BLOB and PostgreSQL is di
Thom Brown wrote:
> On 8 February 2011 18:45, Andreas Kretschmer
> wrote:
> > Michael wrote:
> >
> >>
> >> Hello list,
> >>
> >> I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest)
> >> as BLOB and PostgreSQL is displaying it in hex format like so:
> >
> > set:
> >
Here's the error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for
relation pantryitems
pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE
Does the user need to be a superuser, or is there some way to GRANT
this permission (if
On 8 February 2011 18:45, Andreas Kretschmer wrote:
> Michael wrote:
>
>>
>> Hello list,
>>
>> I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest)
>> as BLOB and PostgreSQL is displaying it in hex format like so:
>>
>> $ TERM=vt100 /pfx/bin/psql opensips opensips
>> psql (9.0.2)
>>
Michael wrote:
>
> Hello list,
>
> I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest)
> as BLOB and PostgreSQL is displaying it in hex format like so:
>
> $ TERM=vt100 /pfx/bin/psql opensips opensips
> psql (9.0.2)
> Type "help" for help.
>
> opensips=> select * from sip_trace
From section 15.4 of the manual:
"If you are upgrading from PostgreSQL "9.0.x", the new version can use
your current data files so you should skip the backup and restore steps"
Is 9.0beta4 considered a 9.0.x version, or do I need to backup/restore
when upgrading from that version?
Thanks
On Tue, 2011-02-08 at 21:05 +0900, Fujii Masao wrote:
> On Tue, Feb 8, 2011 at 4:04 AM, Sylvain Rabot wrote:
> > Is it possible to run maintenance commands like ANALYZE, VACUUM, CLUSTER
> > on a standby server ?
>
> No.
>
> Since the effect of the maintenance command on the primary server
> is a
On 2/8/2011 11:58 AM, Robert Fitzpatrick wrote:
> could not load library “C:/Program Files/PostgreSQL/8.3/lib/plperl.dll”:
> The specified module could not be found. SQL state: 58P01
Sorry the correct error I am getting is...
could not load library “C:/Program Files/PostgreSQL/9.0/lib/plperl.dll”
I am upgrading a Windows install from 8.2.x to 9.0.3. ActivePerl 5.8 was
already installed, but when I run the createlang command to install into
my database, I get...
could not load library “C:/Program Files/PostgreSQL/8.3/lib/plperl.dll”:
The specified module could not be found. SQL state: 58P01
Hello Thom,
On Tues., Feb 08, 2011, Thom Brown wrote:
>On 8 February 2011 14:30, Michael wrote:
>> On Tues., Feb 08, 2011, Thom Brown wrote:
>>>On 8 February 2011 13:43, Thom Brown wrote:
On 8 February 2011 13:19, Michael wrote:
> On Tues., Feb 08, 2011, Thom Brown wrote:
>>On 8 Feb
I'm using the following type definition:
create type typedef.BASIC_PEDIGREE as (
DATE_ADDED TIMESTAMP,
DESCRIPTION VARCHAR(128) [10]
)\c
I understand that PostgreSQL doesn't enforce the array length [10]. However,
I'd like to write an application that can retrieve this length AND t
Hello
We have a database running on Windows Server 2008 standard 32bit using Postgres
8.3
If I run a specific query on this database it takes about 4 seconds
If I do explain analyze on the query it takes about 17 seconds and I get this
result in the beginning
Unique (cost=43820.39..43822.51 row
Hi,
I searched PostgreSQL 9.0.3 RPMs for RHEL5, but couldn't find them.
I need to them in my business.
They are not yet on the following page.
http://yum.pgrpms.org/9.0/redhat/rhel-5Server-x86_64/
When is they available?
regards,
--
OTSUKA Kenji
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
Hi,
In file recovery.conf I can define recovery_target_time or
recovery_target_xid.
I have question where I cand found this information?
For@ll
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
On 8 February 2011 14:30, Michael wrote:
>
> Hello Thom,
>
> On Tues., Feb 08, 2011, Thom Brown wrote:
>>On 8 February 2011 13:43, Thom Brown wrote:
>>> On 8 February 2011 13:19, Michael wrote:
On Tues., Feb 08, 2011, Thom Brown wrote:
>On 8 February 2011 12:45, Michael wrote:
>> On T
Hello Thom,
On Tues., Feb 08, 2011, Thom Brown wrote:
>On 8 February 2011 13:43, Thom Brown wrote:
>> On 8 February 2011 13:19, Michael wrote:
>>> On Tues., Feb 08, 2011, Thom Brown wrote:
On 8 February 2011 12:45, Michael wrote:
> On Tues., Feb 08, 2011, Thom Brown wrote:
>>On 8 Febr
On Tue, Feb 08, 2011 at 02:21:08PM +, Thom Brown wrote:
> > $ ls -l pg_xlog/ | head
> > total 2620721
> > -rw--- 1 postgres postgres 249 Sep 8 20:14
> > 000103DB003E.61A8.backup
> > -rw--- 1 postgres postgres 16777216 Feb 8 11:39
> > 0001076D00F7
On 8 February 2011 14:07, hubert depesz lubaczewski wrote:
> hi
> we had a problem with archiving. so pg_xlog accumulated more wal
> segments.
>
> archive_command was modified to version that doesn't fail, and it is
> working ok. but old segments are still in pg_xlog.
>
> they are way past anythin
Hello Thom,
On Tues., Feb 08, 2011, Thom Brown wrote:
>On 8 February 2011 13:43, Thom Brown wrote:
>> On 8 February 2011 13:19, Michael wrote:
>>> On Tues., Feb 08, 2011, Thom Brown wrote:
On 8 February 2011 12:45, Michael wrote:
> On Tues., Feb 08, 2011, Thom Brown wrote:
>>On 8 Febr
hi
we had a problem with archiving. so pg_xlog accumulated more wal
segments.
archive_command was modified to version that doesn't fail, and it is
working ok. but old segments are still in pg_xlog.
they are way past anything that could be even remotely needed:
# g_controldata .
pg_control versio
Hello Karsten,
On Tues., Feb 08, 2011, Karsten Hilbert wrote:
>On Tue, Feb 08, 2011 at 02:19:49PM +0100, Michael wrote:
The arrow in the last line indicates that 'convert_from' is not
correctly parsed.
>>>My understanding was that your msg column was of type bytea. Is this
>>>not
On 8 February 2011 13:43, Thom Brown wrote:
> On 8 February 2011 13:19, Michael wrote:
>>
>> Hello Thom,
>>
>> On Tues., Feb 08, 2011, Thom Brown wrote:
>>>On 8 February 2011 12:45, Michael wrote:
On Tues., Feb 08, 2011, Thom Brown wrote:
>On 8 February 2011 10:39, Michael wrote:
>>
On 8 February 2011 13:19, Michael wrote:
>
> Hello Thom,
>
> On Tues., Feb 08, 2011, Thom Brown wrote:
>>On 8 February 2011 12:45, Michael wrote:
>>> On Tues., Feb 08, 2011, Thom Brown wrote:
On 8 February 2011 10:39, Michael wrote:
> opensips=> select * from sip_trace;
> id | time_s
On Tue, Feb 08, 2011 at 02:19:49PM +0100, Michael wrote:
> >> The arrow in the last line indicates that 'convert_from' is not
> >> correctly parsed.
> >>
> >My understanding was that your msg column was of type bytea. Is this
> >not the case? Or is it a different column which needs converting?
>
Hello Thom,
On Tues., Feb 08, 2011, Thom Brown wrote:
>On 8 February 2011 12:45, Michael wrote:
>> On Tues., Feb 08, 2011, Thom Brown wrote:
>>>On 8 February 2011 10:39, Michael wrote:
opensips=> select * from sip_trace;
id | time_stamp | callid | traced_user | msg | method | ...
On 8 February 2011 12:45, Michael wrote:
>
> Hello Thom,
>
> I sent this accidentally to you directly, here's a copy for the
> list as well.
>
> On Tues., Feb 08, 2011, Thom Brown wrote:
>>On 8 February 2011 10:39, Michael wrote:
>>> opensips=> select * from sip_trace;
>>> id | time_stamp | calli
Hello Thom,
I sent this accidentally to you directly, here's a copy for the
list as well.
On Tues., Feb 08, 2011, Thom Brown wrote:
>On 8 February 2011 10:39, Michael wrote:
>> opensips=> select * from sip_trace;
>> id | time_stamp | callid | traced_user | msg | method | ...
>> 1234 | 2011-02-
Hello Karsten,
On Tues., Feb 08, 2011, Karsten Hilbert wrote:
>On 8 February 2011 10:39, Michael wrote:
>> I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest)
>> as BLOB
>
>I take it you mean BYTEA.
>
That's probably correct, yes.
>> and PostgreSQL is displaying it in hex format l
On Tue, 2011-02-08 at 19:09 +0900, OTSUKA Kenji wrote:
>
> I searched PostgreSQL 9.0.3 RPMs for RHEL5, but couldn't find them.
> I need to them in my business.
> They are not yet on the following page.
> http://yum.pgrpms.org/9.0/redhat/rhel-5Server-x86_64/
In the next 2 days. There is an issue
2011/2/7 Carlos Mennens
> On Fri, Feb 4, 2011 at 5:08 PM, Dmitriy Igrishin
> wrote:
> > These all (SUPERUSER, CREATEDB, SUPERUSER) are role attributes.
> > By performing ALTER ROLE postgres NOSUPERUSER it is possible to
> > turn role with a superuser status into a role that just can create
> dat
On Tue, Feb 8, 2011 at 4:04 AM, Sylvain Rabot wrote:
> Is it possible to run maintenance commands like ANALYZE, VACUUM, CLUSTER
> on a standby server ?
No.
Since the effect of the maintenance command on the primary server
is also replicated, you don't need to do that on the standby.
Regards,
-
On Tue, Feb 08, 2011 at 11:39:04AM +0100, Michael wrote:
> I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest)
> as BLOB
I take it you mean BYTEA.
> and PostgreSQL is displaying it in hex format like so:
>
> $ TERM=vt100 /pfx/bin/psql opensips opensips
> psql (9.0.2)
> Type "help
On 8 February 2011 10:39, Michael wrote:
>
> Hello list,
>
> I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest)
> as BLOB and PostgreSQL is displaying it in hex format like so:
>
> $ TERM=vt100 /pfx/bin/psql opensips opensips
> psql (9.0.2)
> Type "help" for help.
>
> opensips=> se
Hello list,
I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest)
as BLOB and PostgreSQL is displaying it in hex format like so:
$ TERM=vt100 /pfx/bin/psql opensips opensips
psql (9.0.2)
Type "help" for help.
opensips=> select * from sip_trace;
id | time_stamp | callid | traced_us
Jens,
have you tried german compound dictionary from
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
Oleg
On Tue, 8 Feb 2011, Jens Sauer wrote:
Hey,
thanks for your answer.
First I checked the links in the tsearch_data directory
de_de.affix, and de_de.dict are symlinks to the corre
On 8 February 2011 09:22, Itagaki Takahiro wrote:
> On Mon, Feb 7, 2011 at 20:38, Thom Brown wrote:
>> Yes, of course, int8 functions are separate. I attach an updated
>> patch, although I still think there's a better way of doing this.
>
> Thanks. Please add the patch to the *current* commitfes
Hi,
I searched PostgreSQL 9.0.3 RPMs for RHEL5, but couldn't find them.
I need to them in my business.
They are not yet on the following page.
http://yum.pgrpms.org/9.0/redhat/rhel-5Server-x86_64/
When are they available?
regards,
--
OTSUKA Kenji
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
Hi
2011/2/8 Thomas Markus :
> hi,
>
> i would prefer many schemas. advantages:
> - one backup/restore for all (or selective)
> - one connection pool
> - simple access to all schemas
>
+1
and one disadvantage
- impossible separation on independent hw, when it is necessary or
when you has more hw
hi,
i would prefer many schemas. advantages:
- one backup/restore for all (or selective)
- one connection pool
- simple access to all schemas
regards
thomas
Am 08.02.2011 09:30, schrieb Szymon Guz:
Hi,
is there any noticeable difference between a cluster with many databases and
a database wit
On Mon, Feb 7, 2011 at 20:38, Thom Brown wrote:
> Yes, of course, int8 functions are separate. I attach an updated
> patch, although I still think there's a better way of doing this.
Thanks. Please add the patch to the *current* commitfest
because it's a bugfix.
https://commitfest.postgresql.org
One way to get around the problem is often to do a left or right join,
use = instead of <> , and catch the rows with null in id field,
something like:
SELECT a.* from
table a LEFT JOIN tableb b on a.testfld=b.testfld
WHERE b.id is null;
This one will use indexes on testflda and testfldb an
HTH
Is it possible to add some operator class in Postgresql 9 so that <>(not
equal to) in where clause can use index?
If yes how?
Any idea please.
Hi,
is there any noticeable difference between a cluster with many databases and
a database with many schemas?
I've got a quite huge database on Oracle with about 400 logically disjoint
schemas.
I could import that into PostgreSQL as many different databases, or as one
database with many schemas.
75 matches
Mail list logo
