Oliver Jowett <[EMAIL PROTECTED]> writes:
> Bernard was also objecting to the overhead of pushing the data down a
> TCP pipe when it's already available locally, I think.. I didn't find
> any real difference there when I compared the two methods, though.
What makes you think it's necessarily ava
Andrew
On Fri, 19 Aug 2005 04:17:16 -, you wrote:
>> In the majority of bulk load cases, the input exists as a file already
>
>But not necessarily on the server.
True. But I am concerned with the server, and there I want that things
are handled on the server, not on the client.
>
>> The use
Am Donnerstag, den 18.08.2005, 12:36 -0500 schrieb Peter Fein:
> Hi-
>
> Is there any way to have the *server* timeout disconnected clients? I'm
> connecting over a sometimes flaky WiFi connection & when it goes down,
> I'm left with several open idle sessions. Is there a way to have the
> serve
am 18.08.2005, um 12:36:26 -0500 mailte Peter Fein folgendes:
> Hi-
>
> Is there any way to have the *server* timeout disconnected clients? I'm
> connecting over a sometimes flaky WiFi connection & when it goes down,
> I'm left with several open idle sessions. Is there a way to have the
> serve
Tom Lane wrote:
> Oliver Jowett <[EMAIL PROTECTED]> writes:
>
>>It sounds like what you really want is the ability to grant something
>>like FILE access without granting all superuser rights? Sounds like a
>>feature request, not a bug, to me :-)
>
>
> AFAICT, the complaint really boils down to t
Tom Lane wrote:
> What is the story on JDBC COPY support, anyway? I'm aware that there's
> an unofficial patch for that, but I'm not clear about why it's not made
> it into the accepted version.
I didn't like the whole "here is an undifferentiated stream of data"
approach -- there were some JDBC
Oliver Jowett <[EMAIL PROTECTED]> writes:
> It sounds like what you really want is the ability to grant something
> like FILE access without granting all superuser rights? Sounds like a
> feature request, not a bug, to me :-)
AFAICT, the complaint really boils down to there not being any support
f
[ A bit off topic, but... ]
Oliver Jowett <[EMAIL PROTECTED]> writes:
> And please fix your anti-spam system so it doesn't send me a "you must
> jump through these hoops to send me email" message every time please!
It's standard policy on the PG lists that we boot subscribers who
auto-reply to li
On Thu, 2005-08-18 at 17:02 +0300, Andrus wrote:
> I created generic (for tables in different schemas) trigger function :
>
> CREATE OR REPLACE FUNCTION setlastchange() RETURNS "trigger"
> AS $$BEGIN
> UPDATE serverti SET lastchange='now' WHERE tablename=TG_RELNAME and
>schemaname=TG_SCHEMA;
Mike Nolan wrote:
Your new password is 87&3jiwkjIJiwkjikmkq,^^2v12hqIwLbvCQQQi18152
Do not write it down or save it in a password manager, as doing so
creates security problems.
There is a solution here.
Initialize passwords with a random string. Flag these accounts as
"Password Tempora
On Fri, 19 Aug 2005, Bernard wrote:
> My suggestions for improving the COPY command so it can be used by
> non-superuser users would be as follows:
If you want to do this without switching to a different UNIX user, can't
you already write a small SECURITY DEFINER function as a superuser that
doe
Bernard wrote:
> 2) Split up security risk calculations between the two directions "TO"
> and "FROM" and relax security. Look at MySQL for clues. The
> application developer can manage security on file system permission
> level.
I looked at MySQL's docs briefly and its behaviour seems almost the
Bernard wrote:
> Oliver and interested list members:
[...]
And please fix your anti-spam system so it doesn't send me a "you must
jump through these hoops to send me email" message every time please!
(usual cc: to poster removed for that reason)
-O
---(end of broadcast)
Bernard wrote:
> This difference of performance is the main reason for the COPY
> command, and this is also the reason why bulk loading through the JDBC
> interface will never match the performance of the COPY fith files
> command.
In some admittedly unscientific tests I see less than 10% differe
On 8/18/05, Mike Nolan <[EMAIL PROTECTED]> wrote:
> As I indicated in my original response, there is no best answer to the
> issue of password choices, though there are probably a few 'worst'
> answers. :-)
>
> Once someone has established a password scheme, either randomly generated
> or user s
Oliver and interested list members:
I was referring to the majority of users wanting to "bulk" load tables
not to the majority of all or whatever users who may or may not know
or care about the difference in performance between INSERT and COPY.
This difference of performance is the main reason fo
On Thu, Aug 18, 2005 at 05:20:55PM -0400, Eugene wrote:
> Guys, I really need help on this. Can whoever is in charge of the
> mailing list change it so that it doesn't delete my messages?
I am not in charge of the mail server. However: May I suggest you
change to a less broken mail client? Your
Bernard wrote:
> The majority of JDBC users trying to bulk load tables would not want
> to send the data through their connection. This connection is designed
> to send commands and to transfer only as much data as necessary and as
> little as possible.
I don't understand why this is true at all
I am also seeing this situation using hibernate.
Some of the IDLE-in-transaction connections are sitting
there holding locks which is a BIG problem.
The query I use to see the processes and locks is this:
select procpid, usename , (now() - query_start) as age,
c.relname , l.mode, l.gran
Hello:
I can't to download this version..can you help me?
regards,
Ulises
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Oliver and interested list members:
Thanks for the related information.
The majority of JDBC users trying to bulk load tables would not want
to send the data through their connection. This connection is designed
to send commands and to transfer only as much data as necessary and as
little as poss
Hi,
We have applications that sits on top of Java application server. Our
code is written in Java, sitting on top of Jboss with Hibernate, and
we use JDBC driver pg74.215.jdbc2ee.jar. We have observed a number of
in transaction on pg_stat_activity.
I am wondering if there's command/view/system ta
Bernard wrote:
> I want to follow what is suggested here. How are STDIN and STDOUT
> addressed when using the JDBC driver?
The current JDBC driver doesn't support this mode of COPY.
There was some work done in the past to support this but it never got to
the point of making it into the official
On Thursday 18 August 2005 12:03 am, WireSpot wrote:
> I have two practically identical Debian-testing systems installed
> on two harddrives on the same machine. I've compiled Postgres 8.0.3
> with exactly the same options on both. Both HDD use the same
> kernel, have DMA enabled and so on. I have
On Fri, Aug 19, 2005 at 10:16:29AM +1200, Bernard wrote:
> Bruno and interested list members
>
> I want to follow what is suggested here. How are STDIN and STDOUT
> addressed when using the JDBC driver?
>
> Or in other words where can I write or receive megabytes of data?
I don't know how JDBC d
Bruno and interested list members
I want to follow what is suggested here. How are STDIN and STDOUT
addressed when using the JDBC driver?
Or in other words where can I write or receive megabytes of data?
I would not want to append this to the String of a SQL Statement in
Java because that is a S
Well, perhaps they were blocked for being too large?
Seriously, some of your messages appear to be getting through fine so
if you can't attach them put them on a web or ftp server and post a
link. Much better than copying it to several hundred mailboxes.
On Thu, Aug 18, 2005 at 05:20:55PM -0400,
Guys, I really need help on this. Can whoever is in charge of the mailing list
change it so that it doesn't delete my messages?
thanks,
Eugene
>
> From: Eugene <[EMAIL PROTECTED]>
> Date: 2005/08/18 Thu PM 04:45:58 EST
> To: Tom Lane <[EMAIL PROTECTED]>
> CC:
> Subject: Re: [GENERAL] total d
It seems that I can't. For whatever reason, my messages are being blocked.
Eugene
>
> From: Tom Lane <[EMAIL PROTECTED]>
> Date: 2005/08/18 Thu PM 02:11:54 EST
> To: [EMAIL PROTECTED]
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] total db lockup
>
>
replyAll
Description: null
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Jonathan Villa schrieb:
>
>> Yes, I'm running on Linux
>>
>> I did not try ldconfig, however I just have... and same result
>>
>> tsearch2.so is in /usr/local/pgsql/lib and my home /usr/local/pgsql
>>
>> Also, logs say the same thing that fts.ou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonathan Villa schrieb:
> Yes, I'm running on Linux
>
> I did not try ldconfig, however I just have... and same result
>
> tsearch2.so is in /usr/local/pgsql/lib and my home /usr/local/pgsql
>
> Also, logs say the same thing that fts.out says
I'm
> This way you can let users choose their own passwords :-)
>
> If you like you can put other checks in it to make sure you have any
> three of uppercase/lowercase/numbers/other characters or whatever else
> you like.
Allowing users to choose their own permanent passwords does not make them
any
On Thursday 18 August 2005 10:16 am, [EMAIL PROTECTED] wrote:
> BTW, the default postgresql settings are WAY too conservative.
The archives are full of discussion on this issue. PG runs on several
operating systems and is installed on machines ranging from slow
single-cpu multi-service machines
<[EMAIL PROTECTED]> writes:
> So can anyone offer any insight on this?
Not without information. You haven't even told us what PG version you
are running, much less provided the necessary details like the pg_locks
status.
> BTW, I tried reposting it with attachments and it didn't show up.
Fix yo
> Jonathan Villa schrieb:
>
>> Thanks... at least know I'm doing to correctly... but I still get the
>> errors. I've done everything as it states on the tsearch-V2-intro.html
>> page... and then I run
>>
>> psql ftstest < tsearch2.sql &> fts.out
>>
>> for testing of course
>>
>> the fts.out file
On Thu, Aug 18, 2005 at 01:33:18PM -0400, Vivek Khera wrote:
Hey Vivek! Nice to hear from you over here. ;)
> The trick is dealing with statement timeouts on shared pool
> connections over mod_perl and Apache::DBI. I haven't satisfied
> myself yet that the timeout will be unset when the n
=?ISO-8859-2?Q?Zbigniew_Zag=F3rski?= <[EMAIL PROTECTED]> writes:
> postgres[89874]: [1-1] LOG: XX000: select() failed in postmaster:
> Inappropriate ioctl for device
Wow, that's bizarre.
> After closing all connections, postmaster exits leaving no message in
> logs - these above are last before
Alexandre Barros <[EMAIL PROTECTED]> writes:
> [ can't get more than 64 connections ]
Have you looked into the postmaster log (stderr or syslog output) to
see if any error conditions are being reported?
It occurs to me that the postmaster might be running in an account that
has a max-number-of-us
Hi-
Is there any way to have the *server* timeout disconnected clients? I'm
connecting over a sometimes flaky WiFi connection & when it goes down,
I'm left with several open idle sessions. Is there a way to have the
server disconnect these? A coworker and I have searched the docs/faqs &
haven't
On Aug 16, 2005, at 3:01 PM, Bill Moseley wrote:
So then I wondered if my application should set an alarm and timeout
with an error if, by odd chance, an update hangs. Trying to be a bit
more robust -- not that the application could recover, but at least it
could spit out an error other than h
I think I can answer this cause I recently had a similar problem. There is a
voodoo setting in postgresql called "analyze target". It controls how much
statistic information is kept per table. This information affects the query
planner. If it makes a bad guess based on insufficient statistics da
So can anyone offer any insight on this? BTW, I tried reposting it with
attachments and it didn't show up.
thanks,
Eugene
>
> From: <[EMAIL PROTECTED]>
> Date: 2005/08/18 Thu AM 09:24:30 EST
> To:
> Subject: [GENERAL] total db lockup
>
> (NOTE: reposting this for the *fifth* time because my
On Wed, Aug 17, 2005 at 18:36:55 -0700,
Gary Fay <[EMAIL PROTECTED]> wrote:
> I have a fedora core 3 system. I was able to start the
> postgres server with the tool but I have no idea how
> to create the databases. I am getting errors about my
> user id and I should connect with the one that star
On Wed, Aug 17, 2005 at 15:54:40 -0600,
Edmund <[EMAIL PROTECTED]> wrote:
>
> Great! a simple, dumb program can generate all your passwords in very
> quickly. My 2.4 Ghz Pentium 4 did it in under 10 minutes. A token set of
> 16 characters, and a fixed length of 8 charachters just isnt a very
> Great! a simple, dumb program can generate all your passwords in very
> quickly. My 2.4 Ghz Pentium 4 did it in under 10 minutes. A token set of
> 16 characters, and a fixed length of 8 charachters just isnt a very big
> search space.
Your new password is 87&3jiwkjIJiwkjikmkq,^^2v12hqIwLbvCQQ
Edmund wrote:
[EMAIL PROTECTED] ("Joshua D. Drake") writes:
Fernando Lujan wrote:
Hi folks,
I have a table wich contains my users... I want to insert to each
user
a random password, so I need a random function. Is there such function
in Postgres? I just found the RANDOM which generate
Can't help you with the rest of your problem, but you need to up this
by a factor of 10 at least. This is 8MB of shared buffers for 500
connections...
On Thu, Aug 18, 2005 at 12:43:49PM -0300, Alexandre Barros wrote:
> shared_buffers = 1004 # min 16, at least max_connections*2, 8KB each
Hope th
First of all, thanks in advance for all the replies.
Joshua D. Drake wrote:
max_connections, shared_buffers, shmmax
were tweaked, but the server does not seems to respect the 500
max_connections...
i *know* i'm missing something obvious, but, what could be wrong ?...
i'm lost..
Hi,
I've encountered probably similar problem to one described in
http://archives.postgresql.org/pgsql-general/2005-08/msg00847.php
but have more information.
After some time (about 1000-3000 connections, each one transaction
with 1-50 of selects, updates are rare) postmaster stops receiving
c
On Thu, Aug 18, 2005 at 05:02:58PM +0300, Andrus wrote:
> How to determine schema name where table TG_RELNAME belongs in trigger
> function ?
You could use TG_RELID to query the system catalogs. See the
documentation for pg_class and pg_namespace.
--
Michael Fuhr
---(e
I have a fedora core 3 system. I was able to start the
postgres server with the tool but I have no idea how
to create the databases. I am getting errors about my
user id and I should connect with the one that started
the server, but I used the tool, not a command.
(Stopping the server and using a
On Thu, Aug 18, 2005 at 03:55:43PM +1200, Oliver Jowett wrote:
> Joseph Shraibman wrote:
>
> >>The column's type is 'xid' which the driver doesn't currently handle,
> >>so it gets put into the "wrap it in PGobject" bucket.
> >
> >Is xid a type of number?
>
> It's an internal backend type; I'm no
[EMAIL PROTECTED] ("Joshua D. Drake") writes:
> Fernando Lujan wrote:
> > Hi folks,
> > I have a table wich contains my users... I want to insert to each
> > user
> > a random password, so I need a random function. Is there such function
> > in Postgres? I just found the RANDOM which generates val
Michael Fuhr escreveu:
On Wed, Aug 17, 2005 at 08:24:00AM +, Aliomar Mariano Rego wrote:
Does somebody knows why the Postgresql 7.4.8 or later doesn't supports
the option "SET AUTOCOMMIT TO OFF"?
Because server-side autocommit was a bad idea. See the 7.4 Release Notes.
http://ww
I created generic (for tables in different schemas) trigger function :
CREATE OR REPLACE FUNCTION setlastchange() RETURNS "trigger"
AS $$BEGIN
UPDATE serverti SET lastchange='now' WHERE tablename=TG_RELNAME and
schemaname=TG_SCHEMA;
RETURN NULL;
END$$ LANGUAGE plpgsql STRICT;
Unfortunately,
On Thu, Aug 18, 2005 at 12:03:59PM +0300, WireSpot wrote:
> The actual SELECT results (ie. non EXPLAIN) are identical in both
> cases. The indexes and so on are identical. I've done a reindexing and
> vacuuming on both of them just to be sure.
>
> As you can see, there's quite a bit of a differenc
Hi,
I’m currently using
triggers with postgresql ver. 7.4.6 on Fedora Core 3. I’ve implemented a
dynamic library in `C` that receives all registered trigger. I’m having
a hard time right now since my trigger function is executed even before that any
tr
(NOTE: reposting this for the *fifth* time because my previous messages didn't
go through).
Hi all,
We have experienced a really weird problem with
postgresql yesterday. When I was called in to take a
look, all the non-superuser connections were used up
and they were all in a waiting state (SEL
On Thu, Aug 18, 2005 at 06:26:41AM -0600, Michael Fuhr wrote:
> On Thu, Aug 18, 2005 at 10:03:38AM +0300, WireSpot wrote:
> > However, one application is for some weird reason taking a serious
> > performance hit on certain pages. There are some intensive joins and
> > selects there, but somehow on
On Thu, Aug 18, 2005 at 10:03:38AM +0300, WireSpot wrote:
> However, one application is for some weird reason taking a serious
> performance hit on certain pages. There are some intensive joins and
> selects there, but somehow one install manages a couple of seconds and
> the other takes about 10.
Finaly I follow your suggestion, I use ldap and seems to work (for now).
Thanks for your help
dario
> -Messaggio originale-
> Da: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Per conto di
> Magnus Hagander
> Inviato: lunedì 15 agosto 2005 21.01
> A: Ronzani Dario; pgsql-general@postgres
I have the exact same database on two different systems, both using
8.0.3. I've installed the database from the same dump. Here's the
query I'm trying on each:
EXPLAIN ANALYZE SELECT
answers.*,i18n.field1,i18n.field2,i18n.field3,i18n.field4,i18n.field5
FROM answers LEFT OUTER JOIN i18n on answers.
On Wed, Aug 17, 2005 at 01:14:43PM -0500, Jonathan Villa wrote:
> Thanks... at least know I'm doing to correctly... but I still get the
> errors. I've done everything as it states on the tsearch-V2-intro.html
> page... and then I run
>
> psql ftstest < tsearch2.sql &> fts.out
>
> for testing of
I have two practically identical Debian-testing systems installed on
two harddrives on the same machine. I've compiled Postgres 8.0.3 with
exactly the same options on both. Both HDD use the same kernel, have
DMA enabled and so on. I have the same database and web applications
installed in both syst
64 matches
Mail list logo
