Does anybody have a stored proc they'd like to share (preferably pl/
pgsql) that generates the power set of an array? For instance:
select powerset({1,2,3});
would give 8 rows:
{}
{1}
{2}
{3}
{1,2}
{2,3}
{1,3}
{1,2,3}
---(end of broadcast)
Najib Abi Fadel wrote:
> i have an already running web application with a lot of users. All the
connections to the
> postgresql database are not persistent. I was wondering if it is
possible to switch to
> persistent connection without having problems in my current in
production application in
# [EMAIL PROTECTED] / 2006-09-20 21:59:10 -0400:
> To all involved in this project,
>
> I justed wanted to let you know how impressed and pleased I have been
> with postgres over the past 5 years .
Remember, this is an opens source project. Satisfied users are
similar to random victims i
Alex Turner wrote:
> Is relpages always supposed to be right?:
No, it's only updated on VACUUM, ANALYZE, CREATE INDEX, and perhaps
REINDEX.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
---
Is relpages always supposed to be right?:select count(*) from result_entry;trend=# select count(*) from result_entry; count--- 59913(1 row)trend=# select relpages from pg_class where relname='result_entry';
relpages-- 0(1 row)trend=#Alex
On Sep 22, 2006, at 1:03 PM, Jim C. Nasby wrote:
Berkus doesn't count??! He's got long hair! What more do you want?!
Well, then based on volume he should count as two :-)
No offense intended, Josh... *I'd* count as two, too.
smime.p7s
Description: S/MIME cryptographic signature
On Sep 21, 2006, at 10:27 PM, Christopher Browne wrote:
In contrast, if a similar infringement were found with one of the
products of, say, IBM, you might discover that you got some value for
money out of those licensing fees in that the only folks sued are
likely to be IBM...
That assumes th
On Sep 22, 2006, at 3:20 AM, Alain Roger wrote:When i migrate my DB to another computer, should i recreate all roles manually ?either that or use this command to dump the roles as an SQL file you can feed into the new server. it will complain about trying to recreate the superuser, but that's ign
On Sep 22, 2006, at 3:04 AM, [EMAIL PROTECTED] wrote:If you're database contains foreign keys or similar, make sure to include OIDs into the database dump.on what basis did you make up this advice?i have no OID's anywhere and FK's work just fine.when you set up the new server, be sure to re-create
On Sep 21, 2006, at 10:54 PM, Charles Ambrose wrote:I have a fairly large database tables (say an average of 3Million to 4Million records). Using the pg_dump utility takes forever to dump the Sounds like your either woefully mis-configured or woefully underpowered or have a short definition of "f
> Berkus doesn't count??! He's got long hair! What more do you want?!
banjos playing in background...
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
---(end of broadcast)---
TIP 9: In versions below 8.0, the pl
On Fri, 2006-09-22 at 07:47 +0200, Bo Lorentsen wrote:
> Bill Moran wrote:
> > - No reliability. On slow days, WAL logs could take a long time to
> > rotate, so small but important transactions might not be replicated
> > for a long time.
> >
> So it is all right for backup but for replicat
On Fri, Sep 22, 2006 at 11:14:06AM +0200, Andrew Kelly wrote:
> On Wed, 2006-09-20 at 10:10 -0500, Tony Caduto wrote:
> > Merlin Moncure wrote:
> > > I have seen a steady progressive rise in the number of postgresql
> > > related jobs and the quality of those jobs. Major companies are
> > > appar
On Wed, Sep 20, 2006 at 05:30:59PM -0700, CSN wrote:
> PostgreSQL doesn't have any booth babes? ;P
Berkus doesn't count??! He's got long hair! What more do you want?!
:P
> csn
>
> > On 09/20/06 16:38, Philip Hallstrom wrote:
> > [snip]
> > > I think that description is false. At a certain poi
On Thu, Sep 21, 2006 at 10:48:47AM -0500, Scott Marlowe wrote:
> On Thu, 2006-09-21 at 08:47, Brad Nicholson wrote:
> > On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
> > > > On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
> > > >> For a high level corp manager all they eve
On Thu, 2006-09-21 at 20:14 -0400, Rajarshi Guha wrote:
> Hi, I have a table with 8M rows and one of the fields is a bit (1024
> bits) field. I am trying to dump the bit field for 8M rows to a file:
>
> psql -U cicc3 -A -F " " -t -o pubchem.fp -c "select cid,gfp from
> pubchem_compound;
>
> Howev
I believe there's a TODO item for index-organized tables/clustered
tables. If not, there's certainly been discussion about it on the
-hackers list.
On Sun, Sep 17, 2006 at 10:21:27PM -0700, CG wrote:
> As I'm waiting for a CLUSTER operation to finish, it occurs to me that in a
> lot of cases, the
On Fri, 2006-09-22 at 08:12 +0200, Bo Lorentsen wrote:
> Jeff Davis wrote:
> > 8.2 makes PITR much easier to use for the situation you'd like. In 8.1,
> > a WAL might sit around for a while before it becomes full and then sent
> > off. 8.2 allows you to force a WAL to be sent, and it also allows a
"surabhi.ahuja" <[EMAIL PROTECTED]> writes:
> i am having postgres version 8.0.0 installed, on my machine
^
The 8.0 branch is up to 8.0.8. You have just found one of the reasons
why. Update.
regards, tom lane
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
>> I know, since some Mailinglist I am on are migrated to Majordomo2.
>> Afaik does Mailman not support the "nomail" Option.
>
> BTW, majordomo may not support 'nomail', but it does allow you to add
> additional email addresses to a primary email, wh
If you run it on the same server, with a user who has permission to
access the db using ident (e.g. user "postgres"),
i.e. you have a pg_hba.conf entry like:
local allpostgres ident sameuser
Then pg_dump and pg_dumpall will not require a password.
Alternatively, you can creat
Title: Nachricht
Hm,
depends on how the security settings of the database are set. For local users
you could set in the pg_hba.conf ident as authentication method. Then they won't
need a password anymore.
See
the pg_hba.conf documentation for more infos.
Another way could be to execute the d
Hi,is there a way to backup the database thanks a command script, without postgresql requesting the user password ?thanks a lot,Alain
On Thu, Sep 21, 2006 at 08:14:49PM -0400, Rajarshi Guha wrote:
> Hi, I have a table with 8M rows and one of the fields is a bit (1024
> bits) field. I am trying to dump the bit field for 8M rows to a file:
> out of memory for query result
>
> I am surprised since I did an equivalent query but se
On fim, 2006-09-21 at 21:57 -0400, Brad Budge wrote:
> I have a field that is varchar(15) type and an example of data I'm
> working with is (PROJ-0001-06)
> select cast((max(substring(test.test from 6 for 4))) as integer) + 1
> FROM test where max(substring(test.test from 11 for 2));
>
as someon
On Wed, 2006-09-20 at 10:10 -0500, Tony Caduto wrote:
> Merlin Moncure wrote:
> > I have seen a steady progressive rise in the number of postgresql
> > related jobs and the quality of those jobs. Major companies are
> > apparently rolling out critical infrastructure on postgresql...Vonage
> > is
On fim, 2006-09-21 at 23:40 -0700, Najib Abi Fadel wrote:
> i have an already running web application with a lot of users. All the
> connections to the postgresql database are not persistent. I was
> wondering if it is possible to switch to persistent connection without
> having problems in my cur
Bob Pawley wrote:
I am seeking wording for a procedure that will initiate a trigger only
after another trigger has completed its function. In this case I want to
drop a table that is created and used by the first trigger.
You could just call a function from your trigger, or handle it inside
Hello everyone!
Small update on this issue:
Our server has four 146GB disks as pairwise RAID 1 and one of these is
affected by the bug mentioned in the HP support page.
As quick fix i moved our database to the the other raid device built of
unaffected disks. Till now i don't got any new database c
Title: Nachricht
Hi
Alain!
To get
all the users and so on to the other machine, you have to use the pg_dumpall
tool with the -g switch. This will dump out all the users, groups and roles i
think.
--
Matthias
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTE
Hi,I've checked in pg_dump and i did not find anything regarding backuping roles ?When i migrate my DB to another computer, should i recreate all roles manually ?thx.Alain
Title: Nachricht
Simply
dump the database with pg_dump, copy the dump to the other machine and restore
the dump there.
See
the man pages of pg_dump how to use the tool. If you're database contains
foreign keys or similar, make sure to include OIDs into the database
dump.
--
Matthias
Jeff Davis wrote:
8.2 makes PITR much easier to use for the situation you'd like. In 8.1,
a WAL might sit around for a while before it becomes full and then sent
off. 8.2 allows you to force a WAL to be sent, and it also allows a
standby mode.
This sounds really neat !
To me this sound like
Chander Ganesan wrote:
Keep in mind that while Slony-I provides you with a read-only replica
(able to service queries). At present WAL log replication (in 8.2 or
otherwise) would allow you to have a 'warm standby' type database -
which would be somewhat in sync (pending the latest transactions
Bill Moran wrote:
- No reliability. On slow days, WAL logs could take a long time to
rotate, so small but important transactions might not be replicated
for a long time.
So it is all right for backup but for replication it could end up laking
too much behind, and a fail over could be hou
Csaba Nagy wrote:
That's gone with 8.2, it will be possible to stream the last
modifications, or force a WAL recycle periodically, whatever fits you
better. There is some new infrastructure which allows these things,
although I didn't have the time to play with them.
This sound very nice, wher
36 matches
Mail list logo
