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.
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.
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
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
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
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 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
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
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
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
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
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 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,
-
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, 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
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
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-
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,
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 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?
>
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 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:
>>
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
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 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 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
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
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 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
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
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
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
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 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 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
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”
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
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
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
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)
>>
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
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:
> >
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
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
>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
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
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,
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
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
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
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
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 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
>> 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 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
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 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
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
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
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
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
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
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/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 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 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 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
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 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
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
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
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
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 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.
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
75 matches
Mail list logo
