Re: [GENERAL] About permissions on large objects

On 13/07/2011 8:49 AM, Giuseppe Sacco wrote: Hi all, I moved a few clusters from 8.4 to 9.0 since I required the new way of authenticating against LDAP (or, in my case, AD). Now, I found the new database version introduced permissions on large object, so my application, in order to share large

Re: [GENERAL] About permissions on large objects

option to use the compatibility option and then, when you have updated your code, you can turn off the compatibility mode and run your script once. Howard Cole www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Pg_restore and dump -- General question

On 04/04/2011 11:47 AM, salah jubeh wrote: What will happen if 1. dropped table a 2. insert data on b and the other relations 3. restore table a and it's dependency (table b). Simple advice would be to create a script on an offline system for testing - when you are happy with the results -

[GENERAL] Large Object permissions lost in transfer

objects? Thanks, Howard Cole www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Large Object permissions lost in transfer

configuration variable lo_compat_privileges when I work out how to use it. For the longer term, could I borrow your script for the DO :) I dont seem to have it anymore... but here is a re-created, untested version. do $$ delcare r record; begin for r in select loid from

[GENERAL] Reordering a table

Hi, a puzzle to solve... I have a table with a primary key, and a timestamp, e.g. idstamp 1 2011-02-01 10:00 2 2011-02-01 09:00 3 2011-02-01 11:00 Now for reasons too painful to go into, I need to reorder the id (sequence) so that they are in time order: idstamp 1

Re: [GENERAL] Reordering a table

On 22/02/2011 5:18 PM, Vibhor Kumar wrote: If you are using PG 8.4 then you can try something with row_number as given below: select id,stamp, row_number() over(order by stamp) from test; Or Create table test1 as select row_number() over(order by stamp) as id, stamp from test; Thanks

[GENERAL] Int to Interval conversion

in a query? Thanks. Howard Cole. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Upgrading 8.2.4 to 8.3 With TSearch2

was seamless. Many thanks. Howard Cole www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Upgrading 8.2.4 to 8.3 With TSearch2

build and then dumping that database to restore in an 8.4.3 database, or just dump the existing 8.2.4 database and restore in 8.4.3? Thanks. Howard Cole www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] Large Objects: Sizeof and Deleting Unlinked LOs

my_only_table_that_uses_large_objects) Or are there other things stored in there that I don't know about! Thanks. Howard Cole www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Does PostGreSQL support SSL inbuilt?

to only accept secure connections. Howard Cole -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Configuration Optimisation

something obvious - or is it a waste of time using the pgbench as a judge of optimisation in these circumstances? Thanks. Howard Cole www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] Configuration Optimisation

Leif Biberg Kristensen wrote: On Thursday 14. January 2010 16.02.12 Andy Colson wrote: See my reply above. My 250 tps seems in line with the 700 tps on a modern system that the OP gets on his Windows setup. To me it seems like something is broken on his Ubuntu setup. regards, I am

Re: [GENERAL] Configuration Optimisation

Leif Biberg Kristensen wrote: On Thursday 14. January 2010 16.55.07 Howard Cole wrote: Leif Biberg Kristensen wrote: On Thursday 14. January 2010 16.02.12 Andy Colson wrote: See my reply above. My 250 tps seems in line with the 700 tps on a modern system that the OP gets on his

Re: [GENERAL] Using regex to update a table

'{doc}' for example - as in a set or similar. Is there an alternative I can use to extract just the extension as a string, and to update the non matching columns, setting them to null or empty string? Thanks. Howard Cole www.selestial.com Aha! Found it: update test set extension = substring

Re: [GENERAL] Interesting Benchmark Article

Greg Smith wrote: Howard Cole wrote: Postgres comes out on top for most of the benchmarks against MySQL and SQL Server, in fact in the authors original article he goes as far as recommending using Postgres. More interestingly, the article seems to indicate that W2K8 server is faster

Re: [GENERAL] How to remove non-UTF values from a table?

Phoenix Kiula wrote: On Tue, Dec 15, 2009 at 9:26 PM, Howard Cole howardn...@selestial.com wrote: Phoenix Kiula wrote: An easy question for some I hope. I have a DB from 8.2 days that when I now dump and try to take into the 8.3.7, it gives me errors about utf-8 stuff. I tried

[GENERAL] Interesting Benchmark Article

Stumbled across this post by Joe Stagner of Microsoft: http://misfitgeek.com/blog/aspnet/php-linux-windows-asp-net-performance-ndash-redux/ It is basically a comparisson of ASP.NET vs PHP but it includes comparissons of multiple RDBMS and operating systems. Postgres comes out on top for most

Re: [GENERAL] Too many postgres.exe

a.bhattacha...@sungard.com wrote: Hi All, I have my application UI in Java and which is communicating with Postgresql database. However whenever my application is running I could see there are too many postgres.exe are created even though the application is not doing anything in

Re: [GENERAL] How to remove non-UTF values from a table?

Phoenix Kiula wrote: An easy question for some I hope. I have a DB from 8.2 days that when I now dump and try to take into the 8.3.7, it gives me errors about utf-8 stuff. I tried searching this list's archives but could not come up with an answer. Google returns some sites like these:

Re: [GENERAL] Unexpected EOF on client connection

David Boreham wrote: Sampling the number of connections on my database I decided that the number of connections settled at 6 so I changed my MinPoolSize from 3 to 6. I checked the current state of the database and the number of connections is currently 12. Tonight I shall change the

Re: [GENERAL] Unexpected EOF on client connection

Howard Cole wrote: Thanks Francisco - I currently have MinPoolSize set to 3 (I have a lot of databases on this cluster), I think this copes 90% of the time but I shall set it to 10 and see what happens. Sampling the number of connections on my database I decided that the number

Re: [GENERAL] Unexpected EOF on client connection

Francisco Figueiredo Jr. wrote: Presumably I should never get this error if I use Npgsql? That's correct. But there may be a bug in Npgsql code itself. That's why I asked you to try to raise minpoolvalue to check if you see less errors. I hope it helps. Thanks Francisco - I

[GENERAL] Large Objects and Replication question

Does anyone know of a replication solution that can handle large objects? Preferrably on a per database rather than per cluster basis. Incidentally - out of interest - why doesn't Slony handle large objects? Thanks. Howard www.selestial.com -- Sent via pgsql-general mailing list

[GENERAL] Unexpected EOF on client connection

of 2 to 8 - checking the number of connections at the time, they do not appear to be overloaded. I am running 8.4.1 on Windows 2K3 with a C# application using Npgsql. All connections are to the localhost and there is no firewall. Help! Howard Cole www.selestial.com -- Sent via pgsql-general

Re: [GENERAL] Unexpected EOF on client connection

Richard Broersma wrote: On Tue, Dec 1, 2009 at 7:52 AM, Howard Cole howardn...@selestial.com wrote: I am getting many entries in my log of this type: 2009-12-01 00:13:19 GMTLOG: unexpected EOF on client connection 2009-12-01 00:13:19 GMTLOG could not receive data from client: No connection

Re: [GENERAL] Unexpected EOF on client connection

Howard Cole wrote: Interesting what Francis says about the pool connections being closed before disposal. Apologies Francisco Presumably I should never get this error if I use Npgsql? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] shared_buffers, work_mem and mantenance_work_mem in Windows

Hi, I have not been able to use the tuning wizard in windows for postgresql 8.4 since it stops postgres starting so I have been looking to tweak the postgresql.conf file directly. I am happy with the performance of postgres in general but I feel that it is not utilising the memory on my

Re: [GENERAL] shared_buffers, work_mem and mantenance_work_mem in Windows

Howard Cole wrote: Hi, I have not been able to use the tuning wizard in windows for postgresql 8.4 since it stops postgres starting so I have been looking to tweak the postgresql.conf file directly. I am happy with the performance of postgres in general but I feel that it is not utilising

Re: [GENERAL] upgrade to 8.4 with new character set

but hopefully this shouldn't happen to most people. Hope this helps. Howard Cole www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] upgrade to 8.4 with new character set

of times a day. Howard Cole www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Is data compressed when stored?

Hi everyone, Is data compressed when stored in a database table/field? If not, is there an easy way (invisible to the database client) to compress text and bytea data without actually using compressed disks? Thanks. Howard www.selestial.com -- Sent via pgsql-general mailing list

Re: [GENERAL] Is data compressed when stored?

A. Kretschmer wrote: http://www.postgresql.org/docs/current/static/storage-toast.html Andreas Thanks Andreas. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgadmin is changing pgpass.conf

Richard Huxton wrote: Raymond O'Donnell wrote: On 18/09/2009 16:07, Howard Cole wrote: Thanks for the update. Unfortunately this behaviour has the side effect of deleting passwords that I have set up in the file manually for other applications (namely the backup), which runs under

Re: [GENERAL] pgadmin is changing pgpass.conf

Raymond O'Donnell wrote: On 16/09/2009 10:55, Howard Cole wrote: Hi All, I have been having a few problems with my password file recently, causing my scheduled pg_dump to fail. The problem is that the pgpass.conf file keeps changing. Eventually I narrowed it down to using pgadmin. Every

[GENERAL] pgadmin is changing pgpass.conf

though I do not store my password in pgadmin. This only seems to have become a problem since installing 8.4 and associated version of pgadmin. Is this the desired behaviour or is it a bug? Howard Cole www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Where is tsearch2.sql

Please help :( I have tried to install postgres 8.3.7 on three machines using the pginstaller and none of them appear to install the contrib/tsearch2.sql file. If I look at my old installations (8.3.4 and 8.3.6) then the contrib/tsearch2.sql file is there. Is there a problem with my

Re: [GENERAL] Can I pause the pg_dump or pg_restore

Sam Mason wrote: On Wed, May 20, 2009 at 06:22:46PM +0530, Gurjeet Singh wrote: I don't know if the following would be recommended, but did some research and it seems that one can use STOP and CONT signals on Linux/Unix to pause/continue a process. As David noted; sending a STOP is

Re: [GENERAL] [Windows] Feedback on PG?

driver and the *nix one? The .NET driver (npgsql) is mature and excellent - I am not sure how you integrate it with Delphi but for Microsoft .NET environments it is brilliant. The ease of programming in .NET would make me select it over ODBC every time. Howard Cole. -- Sent via pgsql

Re: [GENERAL] Where is tsearch2.sql

Howard Cole wrote: Please help :( I have tried to install postgres 8.3.7 on three machines using the pginstaller and none of them appear to install the contrib/tsearch2.sql file. If I look at my old installations (8.3.4 and 8.3.6) then the contrib/tsearch2.sql file

Re: [GENERAL] Where is tsearch2.sql

Raymond O'Donnell wrote: On 18/05/2009 23:28, Howard Cole wrote: Just installed 8.3.7 on a W2K3 machine using the pginstaller. I cannot find contrib/tsearch2.sql - I need to import an 8.2 backup with the old tsearch2 but cannot find the new compatibility layer sql file. Hi

[GENERAL] Where is tsearch2.sql

Hi, Just installed 8.3.7 on a W2K3 machine using the pginstaller. I cannot find contrib/tsearch2.sql - I need to import an 8.2 backup with the old tsearch2 but cannot find the new compatibility layer sql file. Where is it??? Thanks, Howard Cole www.selestial.com -- Sent via pgsql-general

[GENERAL] Cannot reattach to shared memory / Windows

Hi, I am running postgres 8.3 on a W2K8 server and appear to be getting lots of cannot reattach to shared memory errors in the log. I used to get these before on a windows 2K3 server but I was under the impression that these were caused by ESET NOD32 antivirus software. But I am not running

Re: [GENERAL] Postgres 8.2.x support on Windows 2008

Raji Sridar (raji) wrote: Hi, I would like to know if Postgres 8.2.x is supported on Windows 2008 (32 bit). If not, what is version of Postgres supported on Windows 2008? PLs let me know. Thanks Raji Hi Raji, Windows Server 2008 is excellent (Sorry if I upset any *nix fanbois). And has

Re: [GENERAL] Pet Peeves?

clever! It gives me an inferiority complex ;) Howard. Howard Cole http://www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] pg_dump -F f

a differential backup of the dumped files. Thanks Howard Cole http://www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Tsearch2 Trigger Problem: pg_catalog.simple does not exist

Hi, I am in the process of updating a database from 8.2 to 8.3 and need a little help with the tsearch2 update. Prior to restoring my 8.3 backup, I ran the tsearch2.sql on the new database, however I am having a little problem with triggers - when I run an update on a table I get the

Re: [GENERAL] Tsearch2 Trigger Problem: pg_catalog.simple does not exist

RTFM! Just read the part about ditching the tsearch2 function. Sincere apologies. Howard. Howard Cole wrote: execute procedure tsearch2('fts','column1','column2'); -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] How to convert ByteA to Large Objects

of the object so I am going to convert these bytea's to large objects so I can chunk the data. Thanks, Howard Cole www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to convert ByteA to Large Objects

. Thank you very much. (P.S. Npgsql is great!) Thanks. Howard Cole www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Server side large object functions

George Weaver wrote: My objective it to read a large object into memory as opposed to exporting it to a disk file. I'm using version 8.3.3, psqlODBC 8.2.2 and vb.net. If you use Npgsql (.NET library) rather than ODBC - there are functions for reading large objects into memory. Howard

Re: [GENERAL] How to reduce impact of a query.

Craig Ringer wrote: Howard Cole wrote: Unfortunately I am on a windows platform. Plus I am running windows software raid so there is little tweaking allowed. Don't write the possibility off too quickly. The driver may well accept parameters for readahead settings etc, either through

Re: [GENERAL] How to reduce impact of a query.

there is something wrong with these databases? The explain analyse seems to come back with identical plans on these. Any ideas? (p.s. I am running autovacuum) Howard Cole www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] How to reduce impact of a query.

Hi, I am running multiple 8.2 databases on a not-so-powerful W2K3 server - and it runs great - for the majority of time. However I have some monster tsearch queries which take a lot of processing and hog system resources - especially disk. I am not concerned with the amount of time or speed

Re: [GENERAL] How to reduce impact of a query.

Teodor Sigaev wrote: The machine in question is a 1GB Ram, AMD 64 with Raid 1 Sata disks. Non standard parts of my postgresql.conf are as follows: max_connections=100 shared_buffers=128MB work_mem=4MB maintenance_work_mem=256MB max_fsm_pages=204800 max_fsm_relations=1500 Any tips appreciated.

Re: [GENERAL] How to reduce impact of a query.

Scott Marlowe wrote: Your entire disk io subsystem is a pair of hard drives. I'm assuming software RAID. Correct. The time that this query takes is not the issue, rather it is the impact that it has on the server - effectively killing it for the 40 seconds due to the heavy disk access.

Re: [GENERAL] How to reduce impact of a query.

Scott Marlowe wrote: The problem is most likely you're I/O bound. If one query is hitting a table it can pull in data (sequentially) at 40 to 80 megabytes per second. Since most of your queries are small, they don't run into each other a lot, so to speak. As soon as your big reporting query

Re: [GENERAL] How to reduce impact of a query.

Scott Marlowe wrote: Best of luck on this. Thanks Scott. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [PERFORM] Backup strategies

Reuven M. Lerner wrote: I'm running a medium-traffic Web site that has been running for a few years, and which uses about four PostgreSQL databases on a regular basis. I'm currently running 8.2, although I'm planning to upgrade to 8.3 in the coming week or two, in part because of the problems

[GENERAL] W2K8

Hello all, Does postgres 8.3.* work on Windows w2k8 x64? I could not find any reference to this on the website. Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] W2K8

I think it does. It certaily works on w2k3 x64 and it should work on w2k8 on x86. I haven't heard a specific report about it working on w2k8 x64, but since I have heard no report that it *doesn't* work, I think you can safely assume that it works :-) Thanks Magnus, Dave. On those assertive

[GENERAL] pg_dump of non nublic schema causes problems on restore.

Appologies if this has already been fixed, but I have come across a problem with pg_dump when dumping a single non-public schema. (This is on Windows Pg 8.2). It did not cause any major problems because I obviously made a backup of the database before I tried a restore, and managed to fix the

[GENERAL] Can I truncate statements in the log?

As part of my log configuration, I log statements that take over 3 seconds. I find this very useful for optimising tables etc. The problem is that it produces verbatim some very large statements which can create huge log entries, which are probably responsible themselves for slowing the system

[GENERAL] POSIX Escape

Hello All, Apologies if this is a bit off-topic. Any hints as to what character sequences need escaping in Postgres's regular expressions? Let me show you the problem. If I want to find all strings that start with 'postgres' I use the regex select str ~ '^postgres'. However if str contains

Re: [GENERAL] Error: Could not open relation...

Looks like someone or something changed the permissions on the postgresql folders or files. Sincerely, Joshua D. Drake I've had a look at this file, and postgres has Full Control. Howard -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Error: Could not open relation...

Howard Cole wrote: Looks like someone or something changed the permissions on the postgresql folders or files. Sincerely, Joshua D. Drake I've had a look at this file, and postgres has Full Control. Howard Further, the system works fine normally. The permissions error appears

Re: [GENERAL] Error: Could not open relation...

Adrian Klaver wrote: On Friday 23 May 2008 6:02 am, Howard Cole wrote: Howard Cole wrote: Looks like someone or something changed the permissions on the postgresql folders or files. Sincerely, Joshua D. Drake I've had a look at this file, and postgres has Full Control

[GENERAL] Error: Could not open relation...

Can anyone give me a hint how to trace the cause of this error message in the error log: ERROR could not open relation 1663/20146/128342: Permission Denied Running 8.2.7 on W2K3. Thanks. Howard Cole. www.selestial.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

[GENERAL] Multiple Database Strategy

I run several databases on a windows server all using the same cluster. Each database is backed up separately using pg_dump - but the size of the databases is leading me to think that the WAL backup strategy will reduce my backup bandwidth. The flaw in this is that the WAL backup is not

[GENERAL] Missing Log File

I've just installed Postgres 8.2.7 on a W2K3 machine, and created the data directory post installation using initdb. Everything appears to be working fine, but there are no log files created. Nor is there a pg_log subdirectory. I have made no changes to the postgresql.conf file. What am I

Re: [GENERAL] Missing Log File

I think I've solved this one - the compared the old to the new postgresql.conf; the new version did not redirect the standard output. Thanks. Howard Cole wrote: I've just installed Postgres 8.2.7 on a W2K3 machine, and created the data directory post installation using initdb. Everything

[GENERAL] Quick Regex Question

Hi all, I don't understand the last result: select 'Ho Ho Ho' ~* '^Ho'; returns true select 'Ho Ho Ho' ~* ' Ho'; returns true select 'Ho Ho Ho' ~* '[^ ]Ho'; returns false (Please note there is a space between ^ and ]) From my limited experience of regex, the last one is searching for either

Re: [GENERAL] Quick Regex Question

Richard Huxton wrote: Howard Cole wrote: Hi all, I don't understand the last result: select 'Ho Ho Ho' ~* '^Ho'; returns true select 'Ho Ho Ho' ~* ' Ho'; returns true select 'Ho Ho Ho' ~* '[^ ]Ho'; returns false (Please note there is a space between ^ and ]) From my limited experience

Re: [GENERAL] Quick Regex Question

Florian, Richard, Ivan. Fantastic response thank you very much. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Quick Regex Question

Martijn van Oosterhout wrote: On Thu, Dec 20, 2007 at 11:51:34AM +0100, A. Kretschmer wrote: am Thu, dem 20.12.2007, um 10:36:08 + mailte Howard Cole folgendes: Your expression works fine Richard, as does '(^| )ho', but can you tell me why '[ ^]ho' doesn't work? With ^ you

Re: [GENERAL] Quick Regex Question

Howard Cole wrote: Martijn van Oosterhout wrote: On Thu, Dec 20, 2007 at 11:51:34AM +0100, A. Kretschmer wrote: am Thu, dem 20.12.2007, um 10:36:08 + mailte Howard Cole folgendes: Your expression works fine Richard, as does '(^| )ho', but can you tell me why '[ ^]ho' doesn't work

Re: [GENERAL] Quick Regex Question

to match the beginning of a name, so to search for 'how' in 'Howard Cole' should match 'col' in 'Howard Cole' should match 'ole' in 'Howard Cole' should NOT match, So using ~* '(^| )col' works for me! As would '(^col| col)' etc. Just as an aside, is there a function that escapes my search string so

Re: [GENERAL] Killing a session in windows

Bruce Momjian wrote: Alvaro Herrera wrote: Bruce Momjian wrote: Alvaro Herrera wrote: Huh, why is it awkward? Alternatively, you can send the signal directly using commandkill/ (or commandpg_ctl kill TERM [process id]/). I think we should mention Windows in

Re: [GENERAL] Killing a session in windows

Dann Corbit wrote: What happens if you disable the net card on your server machine? Hi Dann, The connection is from IIS worker process running on the same machine. My problem is that I want to disable connections for a single database. Disabling the pgsql service or disabling the card

Re: [GENERAL] Killing a session in windows

Thomas H. wrote: On Tue, Dec 11, 2007 at 05:50:46PM -0500, Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Howard Cole wrote: I take it from the lack of response that nobody knows how to kill a connection from the postgresql side on windows? You can't, short of sending a signal

Re: [GENERAL] Killing a session in windows

Which you can do, no? I thought pg_ctl's kill option was invented specifically to make this less painful on Windows. I shall look into the pg_ctl options to see if the kill option does what taskill cannot (thanks for the heads up on that) Using $ pg_ctl kill TERM [pid] worked great. Since

Re: [GENERAL] Killing a session in windows

Thomas H. wrote: wasn't the OP asking for a way to kill active connections to a db? afaik pgAdmin3 does provide this functionality: pgadmin3 tools server status there you can easily terminate connections transactions to a particular db. works pretty well in my test, i can kill active

Re: [GENERAL] Killing a session in windows

there (now redundant for 4 days) and the mysterious connection is still there. There has to be a better solution? Howard. Howard Cole wrote: Hi, I've written about this problem before and thanks to Bill Bartlett and Richard Huxton for previous replies, but the problem keeps coming up... I'm running

[GENERAL] Killing a session in windows

Hi, I've written about this problem before and thanks to Bill Bartlett and Richard Huxton for previous replies, but the problem keeps coming up... I'm running postgresql V8.2.5 (I think!) on W2K3 Server and occasionally I want to rebuild a database. However I cannot drop the database because

[GENERAL] Killing a session on windows

: taskkill /f /pid 1234 This appeared to kill the session, but postgres still thinks the session is live with the same process id. Using the SysInternals process explorer - there doesn't appear to be a process with the given ID. How can I get postgres to drop this session? Thanks Howard Cole

[GENERAL] Table has type character varying, but query expects character varying

I have the following table in a win32 8.2.2 database: (dumped from pgadmin) CREATE TABLE email_directory ( email_directory_id serial NOT NULL, mailbox_id integer NOT NULL, path character varying(255) NOT NULL, marked_for_deletion boolean NOT NULL DEFAULT false, CONSTRAINT

[GENERAL] pgAgent Crash on WinXP

Hi, I have recently started using the pgAgent and I am having some issues with the agent service crashing. The job that I am running has two steps: 1. A vacuum. 2. Backup, which executes the following c:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe -i -h localhost -p 5432 -U postgres -F p

Re: [GENERAL] pgAgent Crash on WinXP

Dave Page wrote: Please try v1.6.3 - there was a bug fixed that might well cause this crash. Regards, Dave. Thanks Dave. I think that has fixed it. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] TSearch2 Problems

Hi Oleg, Everything seemed to work after the vacuum. Thanks for your prompt response. Howard ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] TSearch2 Problems

Hi, I am having some problems with TSearch2 queries since upgrading from 8.0 to 8.2. This is the query: select count(*) from card, to_tsquery('default','test') as q where (q @@ card.fts); This works fine on 8.0 but gives the following error in 8.2: ERROR: No dictionary with name

Re: [GENERAL] TSearch2 Problems

show us output of select * from pg_ts_dict; simple;dex_init(internal);;dex_lexize(internal,internal,integer);Simple example of dictionary. en_stem;snb_en_init(internal);contrib/english.stop;snb_lexize(internal,internal,integer);English Stemmer. Snowball.

Re: [GENERAL] TSearch2 Problems

Oleg, My problem may have been solved by doing a vacuum full analyse. I shall check tomorrow and get back to you. Thanks, Howard. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] pgagent install on windows

. (is it hidden?) 2. The new jobs node does not appear in pgadmin I have tried this on 8.2.1 and 8.2.3. I am getting regular output the application log with log level 2 so the agent appears to be running - its just that I cannot create any jobs? Howard Cole www.selestial.com

Re: [GENERAL] pgagent install on windows

Thanks Dave, you were correct - pgadmin was connecting to template1. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Query Help

Tom Lane wrote: It looks like you have a stale plan for that ON DELETE SET NULL constraint. Was there perhaps an index on operator_id that you removed? Postgres is not very good about flushing cached plans when you change table schemas (something I hope will be fixed in 8.3). If that is the

[GENERAL] Query Help

Hi All, I am getting an error I do not understand from the following setup CREATE TABLE timesheet_booking ( timesheet_booking_id bigserial NOT NULL, operator_id integer, booking_item_id integer, day date NOT NULL, minutes integer NOT NULL, CONSTRAINT timesheet_booking_pkey PRIMARY KEY

[GENERAL] Unknown subdirectories in postgres base directory

Hi All, I am using postgres 8.0 on a windows server and I create and delete database frequently. However I have noticed that the number of subdirectories in the base directory does not reflect the number of databases. Can I delete the directories that do not correspond to the OIDs in:

[GENERAL] Converting Text to Bytea

Hi, Can anyone tell me how to convert a text column to a bytea column? Thanks. Howard Cole www.selestial.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining

[GENERAL] How to enumerate/drop user sessions in windows

. However how can I do this on windows? Is there a psql command to kill sessions? Thanks Howard Cole http://www.selestial.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

  1   2   >