Re: [GENERAL] Validating User

2005-12-28 Thread Michael Fuhr
On Thu, Dec 29, 2005 at 08:10:52AM +0100, ShepherdHill DB Subscriptions wrote: > Please as a superuser how would I obtain an equivalent of this query: > > SELECT * FROM pg_shadow WHERE usename='userid' AND md5(passwd)='passwd' SELECT * FROM pg_shadow WHERE usename = 'userid' AND passwd = 'md5' ||

Re: [GENERAL] Detaching database

2005-12-28 Thread Gregory S. Williamson
> > "Gregory S. Williamson" <[EMAIL PROTECTED]> wrote: > > Petr, > > > > As long as the new server is the same operating system, and the versions of > > postgres are the same, > <...> > > As a clarification, 'versions are the same' needs to be more strict than the > version number (e.g. 8.1.

Re: [GENERAL] Detaching database

2005-12-28 Thread Bruno Wolff III
On Tue, Dec 27, 2005 at 15:49:43 -0800, "Gregory S. Williamson" <[EMAIL PROTECTED]> wrote: > Petr, > > As long as the new server is the same operating system, and the versions of > postgres are the same, you can do a binary copy of the data directory and > move it to the new machine, point the

Re: [GENERAL] importing an Oracle database into Postgres

2005-12-28 Thread Matthew Hixson
Thanks, Jim. I've been playing with OraToPG. So far I've found a couple small problems with it that I'll probably solve with some simple Perl, but overall its a very handy tool. I'll try to post a success story when I get this all straightened out. Cheers, -M@ On Dec 28, 2005, at 1

[GENERAL] Validating User

2005-12-28 Thread ShepherdHill DB Subscriptions
Hi, Please as a superuser how would I obtain an equivalent of this query: SELECT * FROM pg_shadow WHERE usename='userid' AND md5(passwd)='passwd' I browse the content of the pg_shadow and the passwd field shows something like md5... All I am after is to validate a user against pg_shadow table i

Re: [GENERAL] 'AS' column-alias beign ignored on outer select

2005-12-28 Thread Thomas F. O'Connell
On Dec 28, 2005, at 10:03 PM, Thomas F. O'Connell wrote: [snip] If the column alias is being declared in the subselect, the column alias is working. select version(); version - - PostgreSQ

Re: [GENERAL] 'AS' column-alias beign ignored on outer select

2005-12-28 Thread Thomas F. O'Connell
On Dec 2, 2005, at 6:00 AM, Markus Wollny wrote: Hi! Is this the expected behaviour? select ID , USK_RATING AS USK from ( select ID , USK_RATING from MAIN_SONY_PS2_GAME where ID = 101400 limit 1 ) as PRODUCT_LIST limit 1; id | usk_rating +

Re: [GENERAL] I want to know how to improve the security of postgresql

2005-12-28 Thread Qingqing Zhou
""xiapw"" <[EMAIL PROTECTED]> wrote > Hi guys,can you give me some advices about how to improve the security of > postgresql? > Now I major in the security of postgresql and the destination is create a > database with security level of B1(TCSEC),what should I do now,what > program language shou

Re: [GENERAL] POSTGRES DB 3 800 000 rows table, speed up?

2005-12-28 Thread Tom Lane
=?iso-8859-1?Q?Klein_Bal=E1zs?= <[EMAIL PROTECTED]> writes: > Could you explain this a little bit more? > What are the conditions of this situation that makes b-tree ineffective? Well, what he's trying to do is (abstracting a little) WHERE low_bound_col <= probe_value AND probe_value <= high_

Re: [Bulk] Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Jonel Rienton
Please see below -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ted Byers Sent: Wednesday, December 28, 2005 7:29 PM To: Frank L. Parks; pgsql-general@postgresql.org Subject: Re: [Bulk] Re: [GENERAL] Final stored procedure question, for now anyway -

Re: [GENERAL] POSTGRES DB 3 800 000 rows table, speed up?

2005-12-28 Thread Klein Balázs
Could you explain this a little bit more? What are the conditions of this situation that makes b-tree ineffective? Thanks SWK -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: 2005. december 28. 20:04 To: Jim C. Nasby Cc: Eugene; pgsql-gener

[GENERAL] I want to know how to improve the security of postgresql

2005-12-28 Thread xiapw
Hi guys,can you give me some advices about how to improve the security of postgresql? Now I major in the security of postgresql and the destination is create a database with security level of B1(TCSEC),what should I do now,what program language should I use? Thanks! Sting

Re: [Bulk] Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Ted Byers
- Original Message - From: "Frank L. Parks" <[EMAIL PROTECTED]> To: Sent: Wednesday, December 28, 2005 7:27 PM Subject: [Bulk] Re: [GENERAL] Final stored procedure question, for now anyway Do you refresh you database after you add the function? It will not show up until after you

Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Frank L. Parks
Do you refresh you database after you add the function? It will not show up until after you refresh. Ted Byers wrote: Well, I just ran another test and the result indicates the cause of the problem lies elsewhere. I replaced the original function name with "add_entity" and the end result is

Re: [GENERAL] C Function Problem for bytea output

2005-12-28 Thread vishal saberwal
thanks tom, yes it was fopen problem ... the problem was solved when i did chown postgres ... i should have seen that ... thanks, vishOn 12/28/05, Tom Lane <[EMAIL PROTECTED]> wrote: vishal saberwal <[EMAIL PROTECTED]> writes:> I believe its something in the function but i can't spot the error

Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Jonel Rienton
then check what the other fellow suggested, make sure you're creating the function in the right database and the right schema; and checking it in pgAdmin at the same location.   cheers, jonel   From: Ted Byers [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 28, 2005 6:15 PMTo: Jonel Ri

Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Ted Byers
Well, I just ran another test and the result indicates the cause of the problem lies elsewhere.  I replaced the original function name with "add_entity" and the end result is the same.  The function gets stored somewhere, but it is not displayed anywhere by pgAdmin   Any suggestions?

Re: [GENERAL] importing an Oracle database into Postgres

2005-12-28 Thread Matthew Hixson
Hi David, it looks to me like this tool makes an external data source appear to live within Postgres. What I want to do is dump an Oracle database and replace it with Postgres. From that point on I don't ever want to see Oracle again. Can your software be used to accomplish that goal?

Re: [GENERAL] WAL logs multiplexing?

2005-12-28 Thread Trent Shipley
On Wednesday 2005-12-28 05:38, Martijn van Oosterhout wrote: > On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote: > > I'm currently considering setting up online backup procedure and I > > thought maybe it would be a useful feature if the online logs could be > > written into more than o

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Tony Caduto
Yep, we try to keep all the sql in functions/procedures as it makes updates a lot easier and keeps the business logic seperate from the client application. We use native compiled front ends (Delphi) for windows and Lazarus for everything else. When you keep everything in a function/proc it make

Re: FW: Re[2]: [GENERAL] new beginner to postgresql. Looking at

2005-12-28 Thread Chris Travers
Pamela wrote: SQ- ledger.org provided by Dann Corbit has a lot of what I would be looking for plus more. The financials would require a budgeted amount plus requires budgeted minus actual, plus many computations and configurations so that they could at consolidated statements for the churches

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Tino Wildenhain
Tony Caduto schrieb: > Tino Wildenhain wrote: > >> >> We do not talk about exceptions here. I'm talking about transactions. >> And you never know who will be aborting a transaction after your >> call to the function. No need for referral to the fine manuals :-) >> > > Common Tino, you let users a

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Tony Caduto
Tino Wildenhain wrote: We do not talk about exceptions here. I'm talking about transactions. And you never know who will be aborting a transaction after your call to the function. No need for referral to the fine manuals :-) Common Tino, you let users abort transactions? Who else is going to

Re: [GENERAL] Queries never returning...

2005-12-28 Thread Tom Lane
John McCawley <[EMAIL PROTECTED]> writes: > In looking at the "\d tbl_claim" output, there is something odd I > notice. I have many foreign keys (the claim_id in tbl_claim is > referenced by 12 or so other tables, and tbl_claim references about 6 or > so tables by their _id) It seems a good be

Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Jonel Rienton
yup, just use lowercase all the time From: Ted Byers [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 28, 2005 1:45 PMTo: Jonel Rienton; pgsql-general@postgresql.orgSubject: Re: [GENERAL] Final stored procedure question, for now anyway Did you find a fix for it? - Original Messa

Re: [GENERAL] importing an Oracle database into Postgres

2005-12-28 Thread David Fetter
On Wed, Dec 28, 2005 at 12:12:06PM -0800, Matthew Hixson wrote: > What's the best way to import an Oracle database into Postgres? I'm > using Oracle 8.1 and Postgres 8.1.1. DBI-Link. http://pgfoundry.org/projects/dbi-link/ Let me know if you have questions or problems along the way :) Cheers,

Re: [GENERAL] Queries never returning...

2005-12-28 Thread John McCawley
Tom Lane wrote: The differential would have to be index updates or triggers fired by the UPDATE. I'd bet on the latter, but since you've told us zip about your schema or what PG version this is, it's impossible to speculate further... This is my development machine. I'm running PostgreSQ

Re: [GENERAL] importing an Oracle database into Postgres

2005-12-28 Thread Jim C. Nasby
http://archives.postgresql.org/pgsql-advocacy/2005-10/msg00311.php or contrib/oracle are probably your best bet. On Wed, Dec 28, 2005 at 12:12:06PM -0800, Matthew Hixson wrote: > What's the best way to import an Oracle database into Postgres? I'm > using Oracle 8.1 and Postgres 8.1.1. > Thank

Re: [GENERAL] importing an Oracle database into Postgres

2005-12-28 Thread Tom Lane
Matthew Hixson <[EMAIL PROTECTED]> writes: > What's the best way to import an Oracle database into Postgres? I'm > using Oracle 8.1 and Postgres 8.1.1. Look in contrib/oracle/ for some conversion tools. I've never used 'em and don't know if they're any good, but it's a starting point anyway. A

Re: [GENERAL] Queries never returning...

2005-12-28 Thread Ian Harding
On 12/28/05, John McCawley <[EMAIL PROTECTED]> wrote: > I am currently having a problem with a query never finishing (or at > least not in a reasonable amount of time.) I have had similar problems > to this in Postgres over the past several years, and I have always found > workarounds. This time

[GENERAL] importing an Oracle database into Postgres

2005-12-28 Thread Matthew Hixson
What's the best way to import an Oracle database into Postgres? I'm using Oracle 8.1 and Postgres 8.1.1. Thanks, -M@ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Queries never returning...

2005-12-28 Thread Tom Lane
John McCawley <[EMAIL PROTECTED]> writes: > I am currently having a problem with a query never finishing (or at > least not in a reasonable amount of time.) I have had similar problems > to this in Postgres over the past several years, and I have always found > workarounds. This time I'd like

Re: [GENERAL] C Function Problem for bytea output

2005-12-28 Thread Tom Lane
vishal saberwal <[EMAIL PROTECTED]> writes: > I believe its something in the function but i can't spot the error. Well, that sure looks like a NULL result; have you considered the possibility that the fopen is failing? BTW, that code will happily clobber memory that doesn't belong to it if the pa

[GENERAL] Queries never returning...

2005-12-28 Thread John McCawley
I am currently having a problem with a query never finishing (or at least not in a reasonable amount of time.) I have had similar problems to this in Postgres over the past several years, and I have always found workarounds. This time I'd like to actually understand what is happening. I have

Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Ted Byers
Did you find a fix for it? - Original Message - From: Jonel Rienton To: 'Ted Byers' ; pgsql-general@postgresql.org Sent: Wednesday, December 28, 2005 1:24 PM Subject: RE: [GENERAL] Final stored procedure question, for now anyway it's because of the mixed

[GENERAL] C Function Problem for bytea output

2005-12-28 Thread vishal saberwal
hi all, I am trying to read a file from the File System. The function compiles fine, the function is created fine in postgres but the output is NULL/BLANK. The file does exists and has chmod 777 permission. PG_FUNCTION_INFO_V1(file_export); Datum file_export(PG_FUNCTION_ARGS) {     char *FilePat

Re: [GENERAL] POSTGRES DB 3 800 000 rows table, speed up?

2005-12-28 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > On Tue, Dec 27, 2005 at 11:25:37PM +0200, Eugene wrote: >> I ask db like this SELECT * FROM ipdb2 WHERE '3229285376' BETWEEN ipfrom >> AND ipto; > I'm pretty sure PostgreSQL won't be able to use any indexes for this > (EXPLAIN ANALYZE would verify th

Re: [GENERAL] POSTGRES DB 3 800 000 rows table, speed up?

2005-12-28 Thread hubert depesz lubaczewski
On 12/27/05, Eugene <[EMAIL PROTECTED]> wrote: Hello!I've managed to import into postgre DB 3 800 000 rows of data (500 MB pureCSV ~ 2 GB SQL DB)It looks like this"69110784","69111807","US","UNITEDSTATES","ILLINOIS","BLOOMINGTON"," 40.4758","-88.9894","61701","LEVEL 3COMMUNICATIONS INC","DSL-VERIZO

Re: [GENERAL] POSTGRES DB 3 800 000 rows table, speed up?

2005-12-28 Thread Jonel Rienton
I have a question about this, shouldn't it be the query should look like SELECT * FROM ipdb2 WHERE 3229285376 BETWEEN ipfrom AND ipto Note the query doesn't quote the filter, since the ipfrom and ipto are both integer types? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PR

Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Jonel Rienton
it's because of the mixed-case you're using in the function name, i've had this issue last week myself and it seems to be the culprit From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ted ByersSent: Wednesday, December 28, 2005 11:13 AMTo: pgsql-general@postgresql.orgSubject:

Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Guy Rouillier
Ted Byers wrote: > It must be stored somewhere since I get an error saying the function > already exists if I attempt to modiy it slightly and re-run it. For > example, I noticed I used the wrong sequence in the last INSERT > statement. To correct that, I had to add "OR REPLACE" after "CREATE" >

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Randal L. Schwartz
> "Ted" == Ted Byers <[EMAIL PROTECTED]> writes: Ted> Here is a general question relating to this. The problem involves due Ted> diligence related to environmental protection. Consider a distributed Ted> application to support this. You have a facility with an Ted> environmental monitoring

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Ted Byers
- Original Message - From: "Vivek Khera" <[EMAIL PROTECTED]> To: "PG-General General" Sent: Wednesday, December 28, 2005 11:48 AM Subject: Re: [GENERAL] sending mail from Postgres On Dec 28, 2005, at 8:28 AM, Christopher Browne wrote: Some separate process (perhaps polling, perha

Re: [GENERAL] just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?

2005-12-28 Thread Jim C. Nasby
decibel=# set log_min_error_statement=error; SET decibel=# select 1 2; ERROR: syntax error at or near "2" at character 10 LINE 1: select 1 2; ^ decibel=# \q [EMAIL PROTECTED]:47]~:21%tail -n 2 /opt/local/var/log/pgsql8/postgres.log ERROR: syntax error at or near "2" at character

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Tino Wildenhain
Tony Caduto schrieb: > Tino Wildenhain wrote: > >> How do you stop your server sending mail in case a transaction goes >> wild and is sending mails for every updated row in a some megs table? >> > > It would not be smart to send a email via a trigger that updates or > inserts 1000s of rows would

Re: [GENERAL] Adding columns to a view

2005-12-28 Thread Randal L. Schwartz
> "Ingo" == Ingo van Lil <[EMAIL PROTECTED]> writes: Ingo> Well, in my case the situation is further complicated by the fact that Ingo> adding a column to the view should be done automatically from a trigger Ingo> function. I wanted some kind of matrix view that had a column for every Ingo> ro

Re: [GENERAL] POSTGRES DB 3 800 000 rows table, speed up?

2005-12-28 Thread Jim C. Nasby
On Tue, Dec 27, 2005 at 11:25:37PM +0200, Eugene wrote: > I've indexed first two columns they are IPfrom, IPto also table is btree > version of postgre is 7.4.8, on hosting You should ask them to upgrade; 7.4 is getting pretty old. > I ask db like this SELECT * FROM ipdb2 WHERE '3229285376' BETW

[GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Ted Byers
OK, I finally have Postgres accepting my stored procedure.  here is the relevant data in the history window of pgAmind III Query: = -- Executing query:CREATE OR REPLACE FUNCTION addEntity ( fn IN VARCHAR, ln IN VARCHAR, ivar IN VARCHAR, hi IN VARCHAR, pw IN VA

Re: [GENERAL] WAL logs multiplexing?

2005-12-28 Thread Dmitry Panov
On Wed, 2005-12-28 at 16:38 +, Ian Harding wrote: > On 12/28/05, Dmitry Panov <[EMAIL PROTECTED]> wrote: > > On Wed, 2005-12-28 at 11:05 -0500, Tom Lane wrote: > > > Dmitry Panov <[EMAIL PROTECTED]> writes: > > > > Yes, but if the server has crashed earlier the script won't be called > > > > an

Re: [GENERAL] Is CREATE TYPE an alias for CREATE DOMAIN?

2005-12-28 Thread Jim C. Nasby
On Thu, Dec 22, 2005 at 05:16:16PM +0100, Peter Eisentraut wrote: > Jim C. Nasby wrote: > > Some (most?) database's idea of 'creating a type' is actually what we > > consider creating a domain, > > Which databases do such a thing? IIRC, Oracle, DB2, Sybase and MSSQL, though my memory's rusty... a

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Vivek Khera
On Dec 28, 2005, at 8:28 AM, Christopher Browne wrote: Some separate process (perhaps polling, perhaps using NOTIFY/LISTEN) would then grab messages from the table and submit them to [whatever is the communications layer]. That is a clean sort of design for that sort of thing. This is precis

Re: [GENERAL] just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?

2005-12-28 Thread Vivek Khera
On Dec 28, 2005, at 9:46 AM, Frank van Vugt wrote: I may be overlooking some option here, but somewhere between the v7 series and the current v8.1.1 that I'm using, failed queries stopped being logged, only the error message appears in the log (config option log_statement = all). I.e. ex

Re: [GENERAL] FW: deleted records

2005-12-28 Thread Michael Fuhr
On Wed, Dec 28, 2005 at 02:15:24PM +0100, H.J. Sanders wrote: > is there a way to find out how many deleted records there are in > a table (this gives an indication that it is time to vacuum)? Use the pgstattuple() function from contrib/pgstattuple. test=> CREATE TABLE foo (x integer); CREATE TAB

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Tony Caduto
Tino Wildenhain wrote: How do you stop your server sending mail in case a transaction goes wild and is sending mails for every updated row in a some megs table? It would not be smart to send a email via a trigger that updates or inserts 1000s of rows would it? All the times I have used PL P

Re: [GENERAL] WAL logs multiplexing?

2005-12-28 Thread Ian Harding
On 12/28/05, Dmitry Panov <[EMAIL PROTECTED]> wrote: > On Wed, 2005-12-28 at 11:05 -0500, Tom Lane wrote: > > Dmitry Panov <[EMAIL PROTECTED]> writes: > > > Yes, but if the server has crashed earlier the script won't be called > > > and if the filesystem can't be recovered the changes will be lost.

Re: [GENERAL] WAL logs multiplexing?

2005-12-28 Thread Dmitry Panov
On Wed, 2005-12-28 at 11:05 -0500, Tom Lane wrote: > Dmitry Panov <[EMAIL PROTECTED]> writes: > > Yes, but if the server has crashed earlier the script won't be called > > and if the filesystem can't be recovered the changes will be lost. My > > point is the server should write into both (or more)

Re: [GENERAL] WAL logs multiplexing?

2005-12-28 Thread Tom Lane
Dmitry Panov <[EMAIL PROTECTED]> writes: > Yes, but if the server has crashed earlier the script won't be called > and if the filesystem can't be recovered the changes will be lost. My > point is the server should write into both (or more) files at the same > time. As for that, I agree with the ot

Re: [GENERAL] Adding columns to a view

2005-12-28 Thread Ingo van Lil
On 28 Dec 2005, Florian G. Pflug wrote: > >I could think of a few situations where extending a view might be > >useful, and I'd appreciate to see it supported. I don't see any reason > >not to allow it as long as no existing columns are removed or have their > >type changed. > > Well, some other v

Re: [GENERAL] WAL logs multiplexing?

2005-12-28 Thread Dmitry Panov
On Wed, 2005-12-28 at 10:39 -0500, Tom Lane wrote: > Dmitry Panov <[EMAIL PROTECTED]> writes: > > I'm currently considering setting up online backup procedure and I > > thought maybe it would be a useful feature if the online logs could be > > written into more than one place (something like oracle

Re: [GENERAL] just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?

2005-12-28 Thread Tom Lane
Frank van Vugt <[EMAIL PROTECTED]> writes: > I may be overlooking some option here, but somewhere between the v7 series > and > the current v8.1.1 that I'm using, failed queries stopped being logged, only > the error message appears in the log (config option log_statement = all). See log_min_er

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Tino Wildenhain
Tony Caduto schrieb: > Tino, > I am talking about corporate apps, there would never be thousands of > emails in the email servers inbound queue from just a few database > applications. (anyway a thousand emails in a Postfix queue is nothing) > > Sometimes it is best to send the email right from th

Re: [GENERAL] DB crash after disk full

2005-12-28 Thread Tom Lane
Vilen Tambovtsev <[EMAIL PROTECTED]> writes: > - 2005-12-28 19:02:49 NOVT - - 2747: PANIC: could not access status of > transaction 74678708 What Postgres version is this? regards, tom lane ---(end of broadcast)--- TIP

Re: [GENERAL] WAL logs multiplexing?

2005-12-28 Thread Tom Lane
Dmitry Panov <[EMAIL PROTECTED]> writes: > I'm currently considering setting up online backup procedure and I > thought maybe it would be a useful feature if the online logs could be > written into more than one place (something like oracle redo logs > multiplexing). You can do whatever you want

Re: [GENERAL] WAL logs multiplexing?

2005-12-28 Thread Ian Harding
On 12/28/05, Dmitry Panov <[EMAIL PROTECTED]> wrote: > On Wed, 2005-12-28 at 13:38 +0100, Martijn van Oosterhout wrote: > > On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote: > > > I'm currently considering setting up online backup procedure and I > > > thought maybe it would be a useful

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Tony Caduto
And you can code a trigger that fires when there is a difference of 60 days between dates(I have apps that do so...,and the trigger sends a email) I guess I should expand on this more, the trigger is fired via a insert/update into a table called logons, when a user logs on to the system a re

[GENERAL] just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?

2005-12-28 Thread Frank van Vugt
Hi, I may be overlooking some option here, but somewhere between the v7 series and the current v8.1.1 that I'm using, failed queries stopped being logged, only the error message appears in the log (config option log_statement = all). I.e. executing select 1 2; will result in just the

Re: FW: Re[2]: [GENERAL] new beginner to postgresql. Looking at it

2005-12-28 Thread Joshua Kramer
You might also try Quasar Accounting, which is GPL and has graphical client frontends for both Linux and Windows. http://www.linuxcanada.com And yes, it does run on PG. On Tue, 27 Dec 2005, Pamela wrote: I would prefer using linux. I have worked in a limited capacity with both linux and

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Tony Caduto
Tino, I am talking about corporate apps, there would never be thousands of emails in the email servers inbound queue from just a few database applications. (anyway a thousand emails in a Postfix queue is nothing) Sometimes it is best to send the email right from the client app, but in many sit

Re: [GENERAL] DB crash after disk full

2005-12-28 Thread Vilen Tambovtsev
Got to make it work, but now, when i try to make a dump it says pg_dump: SQL command failed pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 2969644 pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor tried reindex: reindexdb: reindexing of database "hostel

[GENERAL] POSTGRES DB 3 800 000 rows table, speed up?

2005-12-28 Thread Eugene
Hello! I've managed to import into postgre DB 3 800 000 rows of data (500 MB pure CSV ~ 2 GB SQL DB) It looks like this "69110784","69111807","US","UNITED STATES","ILLINOIS","BLOOMINGTON","40.4758","-88.9894","61701","LEVEL 3 COMMUNICATIONS INC","DSL-VERIZON.NET" "69111808","69112831","US"

Re: [GENERAL] copy csv eclosed by analog quotes problem superuser ?

2005-12-28 Thread George Pavlov
use this: $ psql -Uyer_user -dyer_database -fyer_copy_script.sql < yer_data_file.csv where yer-copy-script.sql is: -- - drop table foo; create table foo ( c01 varchar, c02 varchar, c03 varchar, c04 varchar, c05 varchar, c06 varchar, c07 varchar, c08 varchar,

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Christopher Browne
> On Tue, 2005-12-27 at 20:58 -0800, Randal L. Schwartz wrote: >> > "Tony" == Tony Caduto <[EMAIL PROTECTED]> writes: >> >> Tony> Check out my site at http://www.amsoftwaredesign.com >> >> Tony> and click on the forums link, I have some examples on how to send a >> Tony> email from a function

Re: [GENERAL] Automatic recovery process

2005-12-28 Thread Martijn van Oosterhout
On Wed, Dec 28, 2005 at 02:13:14PM +0100, Grzegorz Ta?czyk wrote: > So why after closing all connections database system starts up > immediately? This problem also occurs when backend starts up before > database system and there are connections pending. Always the best > solution is to restart back

[GENERAL] FW: deleted records

2005-12-28 Thread H.J. Sanders
Hi Folks. Couldn't find it in any mailing list so: is there a way to find out how many deleted records there are in a table (this gives an indication that it is time to vacuum)? Many thanks Henk Sanders ---(end of broadcast)--

Re: [GENERAL] Automatic recovery process

2005-12-28 Thread Grzegorz Tańczyk
Hello Martijn, Wednesday, December 28, 2005, 1:17:54 PM, you wrote: MvO> > My question is about the last line. Does those connections slow down MvO> > database startup process? Now it looks like that they do, because MvO> > when I shutdown backend then database starts immediatel, but I'm not

Re: [GENERAL] WAL logs multiplexing?

2005-12-28 Thread Dmitry Panov
On Wed, 2005-12-28 at 13:38 +0100, Martijn van Oosterhout wrote: > On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote: > > I'm currently considering setting up online backup procedure and I > > thought maybe it would be a useful feature if the online logs could be > > written into more th

[GENERAL] DB crash after disk full

2005-12-28 Thread Vilen Tambovtsev
Hello, My disk went out of space, so pgsql crashed, and had some FS troubles occurred. I fixed FS, then tried to start and got this: - 2005-12-28 19:02:49 NOVT - - 2747: LOG: database system was interrupted at 2005-12-28 19:02:09 NOVT - 2005-12-28 19:02:49 NOVT - - 2747: LOG: checkpoint r

Re: [GENERAL] WAL logs multiplexing?

2005-12-28 Thread Martijn van Oosterhout
On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote: > I'm currently considering setting up online backup procedure and I > thought maybe it would be a useful feature if the online logs could be > written into more than one place (something like oracle redo logs > multiplexing). > > If I

Re: [GENERAL] Automatic recovery process

2005-12-28 Thread Martijn van Oosterhout
On Wed, Dec 28, 2005 at 01:03:16PM +0100, Grzegorz Ta?czyk wrote: > Hello, > > Here is what I see in log file: > > WARNING: terminating connection because of crash of another server process > FATAL: the database system is starting up > (and the last line repeats on each connection generate

[GENERAL] WAL logs multiplexing?

2005-12-28 Thread Dmitry Panov
Hi, I'm currently considering setting up online backup procedure and I thought maybe it would be a useful feature if the online logs could be written into more than one place (something like oracle redo logs multiplexing). If I got it right if the server's filesystem crashes completely then the

[GENERAL] Postgresql web interface tools site

2005-12-28 Thread david robert
Hi Guys,    Finally here is the one place most web interface tools available for postgresql database   http://www.debianhelp.co.uk/postgresqlweb.htm   hopefully you will enjoy this Play Santa's Celebrity Xmas Party, an exclusive game from Yahoo!

[GENERAL] Automatic recovery process

2005-12-28 Thread Grzegorz Tańczyk
Hello, Here is what I see in log file: WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the curre nt transaction and exit, because another server process exited abnormally and po ssibly corrupted s

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Tino Wildenhain
Tony Caduto schrieb: > Randal L. Schwartz wrote: > >> I fear for the future. >> >> Did someone forget what a "database" is for? >> > > You have nothing to fear but fear itself > (FDR http://historymatters.gmu.edu/d/5057/) > > Let us see why this might be handy(sending a email or connecting t

Re: [GENERAL] Storing images in a db (for web/midlet access)

2005-12-28 Thread John Sidney-Woollett
You need to create a servlet (or the equivalent in ASP, PHP etc) that sits between the clients browser and your database. In this layer you implement a cache. The first time the image is requested you retrieve it from the database and serve it normally, but you also copy the byte stream to your

Re: [GENERAL] Detaching database

2005-12-28 Thread Martijn van Oosterhout
On Wed, Dec 28, 2005 at 01:00:27AM +0100, Petr wrote: > I'm try to explain my problems. My customer have Postgre server with any > older version of my DB (without any new or modified views, functions etc.) > and when i create export (in pgAdmin3), then pg_dump makes a SQL script. Ok. > It's nice, b

Re: [GENERAL] sending mail from Postgres

2005-12-28 Thread Tony Caduto
Randal L. Schwartz wrote: I fear for the future. Did someone forget what a "database" is for? You have nothing to fear but fear itself (FDR http://historymatters.gmu.edu/d/5057/) Let us see why this might be handy(sending a email or connecting to a socket server). The email function

[GENERAL] Storing images in a db (for web/midlet access)

2005-12-28 Thread Assad Jarrahian
Hi All, So I am trying to store images in the db which will be accessed from a midlet and website. So I looked into generating temp files, such as the one done here using servlets (http://fdegrelle.over-blog.com/categorie-275139.html). What I am confused about is that this may not be very effic