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 t...@linux.com 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.
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
Hi
2011/2/8 Thomas Markus t.mar...@proventis.net:
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
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
On 8 February 2011 09:22, Itagaki Takahiro itagaki.takah...@gmail.com wrote:
On Mon, Feb 7, 2011 at 20:38, Thom Brown t...@linux.com 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
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
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_user
On 8 February 2011 10:39, Michael postgre...@encambio.com 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.
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 for
On Tue, Feb 8, 2011 at 4:04 AM, Sylvain Rabot sylv...@abstraction.fr 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
2011/2/7 Carlos Mennens carlos.menn...@gmail.com
On Fri, Feb 4, 2011 at 5:08 PM, Dmitriy Igrishin dmit...@gmail.com
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
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 in
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 like so:
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-03 |
On 8 February 2011 12:45, Michael postgre...@encambio.com 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
Hello Thom,
On Tues., Feb 08, 2011, Thom Brown wrote:
On 8 February 2011 12:45, Michael postgre...@encambio.com 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?
The main
On 8 February 2011 13:19, Michael postgre...@encambio.com wrote:
Hello Thom,
On Tues., Feb 08, 2011, Thom Brown wrote:
On 8 February 2011 12:45, Michael postgre...@encambio.com wrote:
On Tues., Feb 08, 2011, Thom Brown wrote:
On 8 February 2011 10:39, Michael wrote:
opensips= select * from
On 8 February 2011 13:43, Thom Brown t...@linux.com wrote:
On 8 February 2011 13:19, Michael postgre...@encambio.com wrote:
Hello Thom,
On Tues., Feb 08, 2011, Thom Brown wrote:
On 8 February 2011 12:45, Michael postgre...@encambio.com wrote:
On Tues., Feb 08, 2011, Thom Brown wrote:
On 8
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 the case? Or is
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
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 February 2011 10:39,
On 8 February 2011 14:07, hubert depesz lubaczewski dep...@depesz.com 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
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 February 2011 10:39,
On 8 February 2011 14:30, Michael postgre...@encambio.com 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
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:
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
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
Hello Thom,
On Tues., Feb 08, 2011, Thom Brown wrote:
On 8 February 2011 14:30, Michael postgre...@encambio.com 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
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:
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 sylv...@abstraction.fr 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
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 postgre...@encambio.com 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
On 8 February 2011 18:45, Andreas Kretschmer akretsch...@spamfence.net wrote:
Michael postgre...@encambio.com 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
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
Thom Brown t...@linux.com wrote:
On 8 February 2011 18:45, Andreas Kretschmer akretsch...@spamfence.net
wrote:
Michael postgre...@encambio.com 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
On 8 February 2011 19:28, Andreas Kretschmer akretsch...@spamfence.net wrote:
Thom Brown t...@linux.com wrote:
On 8 February 2011 18:45, Andreas Kretschmer akretsch...@spamfence.net
wrote:
Michael postgre...@encambio.com wrote:
Hello list,
I'm trying to view text data stored by
Il 08/02/2011 10.42, Pavel Stehule ha scritto:
Hi
2011/2/8 Thomas Markus t.mar...@proventis.net:
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
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 turn
2011/2/8, Mike Christensen m...@kitchenpc.com:
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
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
Thom Brown t...@linux.com wrote:
On 8 February 2011 19:28, Andreas Kretschmer akretsch...@spamfence.net
wrote:
Thom Brown t...@linux.com wrote:
On 8 February 2011 18:45, Andreas Kretschmer akretsch...@spamfence.net
wrote:
Michael postgre...@encambio.com wrote:
Hello list,
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
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 akretsch...@spamfence.net wrote:
Thom Brown t...@linux.com wrote:
On 8 February 2011 18:45, Andreas Kretschmer akretsch...@spamfence.net
wrote:
Michael postgre...@encambio.com wrote:
I'm trying to view
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
On 8 February 2011 22:27, Michael postgre...@encambio.com wrote:
On Tues., Feb 08, 2011, Thom Brown wrote:
On 8 February 2011 19:28, Andreas Kretschmer akretsch...@spamfence.net
wrote:
Thom Brown t...@linux.com wrote:
On 8 February 2011 18:45, Andreas Kretschmer akretsch...@spamfence.net
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
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,
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
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:
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
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
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:
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 Takahiroitagaki.takah...@gmail.com wrote:
On Fri, Feb 4, 2011 at 21:32, Thom Brownt...@linux.com wrote:
The issue is that generate_series will not return if the series hits
either the upper or lower boundary during
On Wed, Feb 9, 2011 at 10:17, Andrew Dunstan and...@dunslane.net 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
On 02/08/2011 08:19 PM, Itagaki Takahiro wrote:
On Wed, Feb 9, 2011 at 10:17, Andrew Dunstanand...@dunslane.net 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
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 SHARE
MODE
On Mon, Jan 31, 2011 at 7:36 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Thom Brown t...@linux.com 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).
On Tue, Feb 8, 2011 at 8:30 PM, Andrew Dunstan and...@dunslane.net 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:
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
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
David Kerr d...@mr-paradox.net 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,
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 way with
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
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
75 matches
Mail list logo