Re: [GENERAL] safelly erasing dirs/files

Greg Smith wrote: how do I un-bloat the /var partition ? this is why I was considering rm I've gotten out of this situation before by finding other files in /var to delete, using something like this to figure out where the big stuff was at: while sometimes /var/log or /var/spool data

Re: [GENERAL] safelly erasing dirs/files

Joao Ferreira gmail wrote: vacuum/reindex is saying: I can't do it cause I have no space :( how do I un-bloat the /var partition ? this is why I was considering rm I've gotten out of this situation before by finding other files in /var to delete, using something like this to figure out w

Re: [GENERAL] all empty tables

On 15/11/2009 5:04 AM, Merlin Moncure wrote: > On Sat, Nov 14, 2009 at 6:01 AM, Craig Ringer > wrote: >> On 14/11/2009 6:12 PM, Garry Saddington wrote: >>> How could I list all the tables in a database that do not contain any data? >>> I have looked at reltuples but can't quite work out how to use

Re: [GENERAL] safelly erasing dirs/files

From the on-line help: |DROP DATABASE| drops a database. It removes the catalog entries for the database and deletes the directory containing the data. Joao Ferreira gmail wrote: Hello all, How can I safelly erase (with rm command in Linux) files or dirs concerning a specific database ? a

Re: [GENERAL] Fast Search on Encrypted Feild

"Naoko Reeves" wrote: > > Merlin, > Thank you for your quick response. I see... our security requirements are: > We are encrypting PII information within our DB and because of the sensitive > nature of our data, we must balancing both performance and security to meet > our client requirements. >

Re: [GENERAL] [pgeu-general] pgday.eu

2009/11/14 Thom Brown > 2009/11/14 Dave Page > >> On 11/14/09, Andreas 'ads' Scherbaum wrote: >> >> > On Sat, Nov 14, 2009 at 10:52:22AM +, Dave Page wrote: >> >> >> >> I think we should spend some money and buy some inexpensive cameras >> >> and tripods along with a bunch of memory cards f

Re: [GENERAL] Upgrading databases

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Greg quoting Greg asks: >> 3. Slony. Setup a slave database, get everything in sync, then >> switch over to the new database. Very minimal

Re: [GENERAL] Fast Search on Encrypted Feild

Naoko Reeves wrote: I have a encrypted column use encrypt function. Querying against this column is almost not acceptable – returning 12 rows took 25,908 ms. The query was simply Select decrypt(phn_phone_enc) FROM phn WHERE decrypt(phn_phone_enc,’xxx’,’xxx’) LIKE ‘123%’ So I built index l

Re: [GENERAL] Fast Search on Encrypted Feild

Merlin, Thank you for your quick response. I see... our security requirements are: We are encrypting PII information within our DB and because of the sensitive nature of our data, we must balancing both performance and security to meet our client requirements. Our clients are mainly lawyers and h

Re: [GENERAL] Fast Search on Encrypted Feild

On Sat, Nov 14, 2009 at 4:27 PM, Naoko Reeves wrote: > I have a encrypted column use encrypt function. > > Querying against this column is almost not acceptable – returning 12 rows > took 25,908 ms. > > The query was simply Select decrypt(phn_phone_enc) FROM phn WHERE > decrypt(phn_phone_enc,’xxx’

[GENERAL] Fast Search on Encrypted Feild

I have a encrypted column use encrypt function. Querying against this column is almost not acceptable - returning 12 rows took 25,908 ms. The query was simply Select decrypt(phn_phone_enc) FROM phn WHERE decrypt(phn_phone_enc,'xxx','xxx') LIKE '123%' So I built index like: CREATE INDEX idx_phn_p

Re: [GENERAL] all empty tables

On Sat, Nov 14, 2009 at 6:01 AM, Craig Ringer wrote: > On 14/11/2009 6:12 PM, Garry Saddington wrote: >> How could I list all the tables in a database that do not contain any data? >> I have looked at reltuples but can't quite work out how to use it, any >> pointers would be much apreciated. > > D

Re: [GENERAL] 8.5devel: alter constraint ?

Jeff Davis wrote: > On Sat, 2009-11-14 at 17:42 +0100, Andreas Kretschmer wrote: > > I'm playing with 8.5devel. > > > > My question: is it possible to alter a constraint without drop and > > rebuilding it? > > > > For instance, i have a table test with a primary key, but i have > > forgotten to

Re: [GENERAL] safelly erasing dirs/files

On Sat, Nov 14, 2009 at 7:42 PM, Joao Ferreira gmail wrote: > vacuum/reindex is saying: I can't do it cause I have no space :( Hm, vacuum shouldn't require any extra space. I suppose you need enough space for the transaction log though. You can probably get away with a pretty small amount of extr

Re: [GENERAL] 8.5devel: alter constraint ?

On Sat, 2009-11-14 at 17:42 +0100, Andreas Kretschmer wrote: > I'm playing with 8.5devel. > > My question: is it possible to alter a constraint without drop and > rebuilding it? > > For instance, i have a table test with a primary key, but i have > forgotten to declare the constraint as DEFERRABL

Re: [GENERAL] Remote Database Connection

Nykolyn, Andy (AS) wrote: Is there a way to set up the pg_hba.conf file to allow users to connect regardless of their IP address? I have users that need to access the database through a VPN using a non static IP address. Thanks in advance. specify a subnet mask that includes all thes

Re: [GENERAL] Remote Database Connection

Nykolyn, Andy (AS) wrote: > Is there a way to set up the pg_hba.conf file to allow users to connect > regardless of their IP address? I have users that need to access the database > through a VPN using a non static IP address. Thanks in advance. Sure, use 0.0.0.0/0 as CIDR-adress. Andreas --

Re: [GENERAL] safelly erasing dirs/files

Joao Ferreira gmail wrote: ok. thx all for the explanation my problem is I a heavilly bloated pg database that has just filled up the partition data is in /var/pgsql/.. and /var is 100% full... vacuum/reindex is saying: I can't do it cause I have no space :( how do I un-bloat the /var partiti

Re: [GENERAL] safelly erasing dirs/files

Joao Ferreira gmail wrote: > my problem is I a heavilly bloated pg database that has just filled up > the partition > > data is in /var/pgsql/.. and /var is 100% full... > > vacuum/reindex is saying: I can't do it cause I have no space :( > > how do I un-bloat the /var partition ? this is why I

[GENERAL] Remote Database Connection

Is there a way to set up the pg_hba.conf file to allow users to connect regardless of their IP address? I have users that need to access the database through a VPN using a non static IP address. Thanks in advance.

Re: [GENERAL] safelly erasing dirs/files

Bill Moran wrote: However, if you're looking for secure data destruction (akin to rm's -P flag) I don't know if there is a canned method for doing so. the only really secure data destruction is to put the disk drives in a chipper and grind them up. don't forget any media that ever held b

Re: [GENERAL] safelly erasing dirs/files

ok. thx all for the explanation my problem is I a heavilly bloated pg database that has just filled up the partition data is in /var/pgsql/.. and /var is 100% full... vacuum/reindex is saying: I can't do it cause I have no space :( how do I un-bloat the /var partition ? this is why I was consid

Re: [GENERAL] safelly erasing dirs/files

Joao Ferreira gmail wrote: How can I safelly erase (with rm command in Linux) files or dirs concerning a specific database ? You can't do it with rm; you need to execute the SQL "drop" command somehow to clean up all the references to that database. If you want to remove a database from the

Re: [GENERAL] safelly erasing dirs/files

Joao Ferreira gmail wrote: > > Hello all, > > How can I safelly erase (with rm command in Linux) files or dirs > concerning a specific database ? What do you mean by this? The typical way would be to log into the DB server and issue DROP DATABASE x. However, if you're looking for secure data d

Re: [GENERAL] safelly erasing dirs/files

Joao Ferreira gmail writes: > How can I safelly erase (with rm command in Linux) files or dirs > concerning a specific database ? Don't even think about it. > assuming I whish to elimiante data belonging to database A but I do not > whish to disturb or cause any injury to database B DROP DATABA

Re: [GENERAL] safelly erasing dirs/files

In response to Joao Ferreira gmail : > Hello all, > > How can I safelly erase (with rm command in Linux) files or dirs > concerning a specific database ? Don't do that! > > assuming I whish to elimiante data belonging to database A but I do not > whish to disturb or cause any injury to database

Re: [GENERAL] XLOG's implementation details

On Nov 13, 2009, at 3:46 AM, Ozgun Erdogan wrote: How strong is the coupling between XLOG entries and database pages? That is, assume that I am inserting one row to a database table. Is there anyway for me to construct the related XLOG entry before calling the heap insert function? Or, are XLOG

Re: [GENERAL] safelly erasing dirs/files

On Fri, Nov 13, 2009 at 12:15 PM, Joao Ferreira gmail < joao.miguel.c.ferre...@gmail.com> wrote: > Hello all, > > How can I safelly erase (with rm command in Linux) files or dirs > concerning a specific database ? > Using 'rm', you can't -- not safely anyways. > > assuming I whish to elimiant

[GENERAL] safelly erasing dirs/files

Hello all, How can I safelly erase (with rm command in Linux) files or dirs concerning a specific database ? assuming I whish to elimiante data belonging to database A but I do not whish to disturb or cause any injury to database B Is there documentation on how to do this or on what exactly am I

Re: [GENERAL] XLOG's implementation details

On Nov 13, 2009, at 3:46 AM, Ozgun Erdogan wrote: How strong is the coupling between XLOG entries and database pages? That is, assume that I am inserting one row to a database table. Is there anyway for me to construct the related XLOG entry before calling the heap insert function? Or, are XLOG

[GENERAL] If you wanna have some fun...

http://www.backtrouble.com/Edc9OK2thv.html -- 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] [pgeu-general] pgday.eu

Andreas 'ads' Scherbaum wrote: >> I think we should spend some money and buy some inexpensive cameras >> and tripods along with a bunch of memory cards for next year, and >> record everything. I know other PUGs/conferences series have done that >> with good results. > On FOSDEM this attempt fail

Re: [GENERAL] [pgeu-general] pgday.eu

2009/11/14 Dave Page > On 11/14/09, Andreas 'ads' Scherbaum wrote: > > On Sat, Nov 14, 2009 at 10:52:22AM +, Dave Page wrote: > >> > >> I think we should spend some money and buy some inexpensive cameras > >> and tripods along with a bunch of memory cards for next year, and > >> record every

Re: [GENERAL] [pgeu-general] pgday.eu

On 11/14/09, Andreas 'ads' Scherbaum wrote: > On Sat, Nov 14, 2009 at 10:52:22AM +, Dave Page wrote: >> >> I think we should spend some money and buy some inexpensive cameras >> and tripods along with a bunch of memory cards for next year, and >> record everything. I know other PUGs/conference

Re: [GENERAL] [pgeu-general] pgday.eu

On Sat, Nov 14, 2009 at 10:52:22AM +, Dave Page wrote: > > I think we should spend some money and buy some inexpensive cameras > and tripods along with a bunch of memory cards for next year, and > record everything. I know other PUGs/conferences series have done that > with good results. On F

[GENERAL] 8.5devel: alter constraint ?

Hi, I'm playing with 8.5devel. My question: is it possible to alter a constraint without drop and rebuilding it? For instance, i have a table test with a primary key, but i have forgotten to declare the constraint as DEFERRABLE. I can drop and recreate that, but the index are also dropped and re

Re: [GENERAL] [pgeu-general] pgday.eu

2009/11/14 Thom Brown > > Mr Fetter has allowed me to post his lightning talk on lightning talks: > http://vimeo.com/7602006 > > Thom > Harald's lightning talk also available with his permission: http://vimeo.com/7610987 Thom

Re: [GENERAL] Voting: "pg_ctl init" versus "initdb"

Zdenek Kotala writes: > Because there is doubt if someone else want this I would like to ask > here for your opinion. There are following options: > 1) Yeah I like pg_ctl init > "pg_ctl init" will be preferred method and initdb will > disappear from usr/bin in the future.

[GENERAL] Voting: "pg_ctl init" versus "initdb"

Hi all, I prepared patch which extend pg_ctl functionality and add "init" command which do same thing like initdb (it calls initdb on the background). The idea behind this is to have only one command which control database. pg_ctl already has "start", "stop", "restart", "reload" and so on. To have

Re: [GENERAL] Rejected token 3A37-A32F-9E8B

good catch on man in the middle forgery postmaster..keep up the good work! Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein,

Re: [GENERAL] pgmemcache vs pgmemcached

Juan, Thom, and Hannu, I'm S. hironobu, pgmemcached maintainer. I add to comments: I made pgmemcached in July, 2008, and up-loaded it to my website. Afterwards, Hannu made pgmemcache2. In about the end in 2008, he became to maintainer of pgmemcahe, I sent him some patches. The roots of pgmemc

Re: [GENERAL] [pgeu-general] pgday.eu

2009/11/14 Dave Page > On Sat, Nov 14, 2009 at 10:49 AM, Thom Brown wrote: > > Had I actually anticipated that I'd record them, I'd have brought my > shotgun > > mic for my camera instead of using the rubbish built-in mic. Oh well :( > It > > would be nice if someone would record the sessions a

Re: [GENERAL] all empty tables

On 14/11/2009 6:12 PM, Garry Saddington wrote: > How could I list all the tables in a database that do not contain any data? > I have looked at reltuples but can't quite work out how to use it, any > pointers would be much apreciated. Define "empty". In a MVCC database, it's harder than you'd thin

Re: [GENERAL] all empty tables

Garry Saddington wrote: > How could I list all the tables in a database that do not contain any data? > I have looked at reltuples but can't quite work out how to use it, any > pointers would be much apreciated. reltuples contains only an estimation, if you need the real values you need to loo

Re: [GENERAL] all empty tables

On lör, 2009-11-14 at 10:12 +, Garry Saddington wrote: > How could I list all the tables in a database that do not contain any data? > I have looked at reltuples but can't quite work out how to use it, any > pointers would be much apreciated. select * from pg_class where relkind = 'r' and rel

Re: [GENERAL] [pgeu-general] pgday.eu

On Sat, Nov 14, 2009 at 10:49 AM, Thom Brown wrote: > Had I actually anticipated that I'd record them, I'd have brought my shotgun > mic for my camera instead of using the rubbish built-in mic. Oh well :(  It > would be nice if someone would record the sessions as part of the event so > that there

Re: [GENERAL] [pgeu-general] pgday.eu

2009/11/14 Dave Page > > If you can add the links for any videos you publish to the wiki page > at http://wiki.postgresql.org/wiki/PGDay.EU%2C_Paris_2009, that would > be good. > > Really? Despite them being shaky and with poor sound? I guess I could. > > Maybe I should try to nick the sound

Re: [GENERAL] [pgeu-general] pgday.eu

On Sat, Nov 14, 2009 at 9:59 AM, Thom Brown wrote: > 2009/11/12 Dave Page >> >> On Thu, Nov 12, 2009 at 12:18 AM, Thom Brown wrote: >> >> > I second that.  I wasn't sure quite what to expect, but it was very >> > well organised and executed.  And thanks to our French hosts whose >> > hard work r

[GENERAL] all empty tables

How could I list all the tables in a database that do not contain any data? I have looked at reltuples but can't quite work out how to use it, any pointers would be much apreciated. Regards Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subsc

Re: [GENERAL] [pgeu-general] pgday.eu

2009/11/12 Dave Page > On Thu, Nov 12, 2009 at 12:18 AM, Thom Brown wrote: > > > I second that. I wasn't sure quite what to expect, but it was very > > well organised and executed. And thanks to our French hosts whose > > hard work really paid off too! The talks were excellent, especially > >

Re: [GENERAL] pgmemcache vs pgmemcached

Is there any documentation on this? PgFoundry doesn't appear to have any. Thanks Thom 2009/11/13 Valtonen, Hannu > On 11/13/09 5:26 AM, Juan Backson wrote: > Hi, > > I had a chat with Suzuki Hironobu (pgmemcached maintainer) earlier this > year and we pretty much decided that pgmemcache was t

[GENERAL] Rejected token 3A37-A32F-9E8B

The mailing list software at postgresql.org has received instructions to reject the following command: "unregister pgsql-general@postgresql.org" Some mailing list commands can be the result of an attempted forgery or mail bombing. This message is being sent to inform you of everything that is

Re: [GENERAL] Can anyone help setting up pgbouncer?

On Sat, Nov 14, 2009 at 00:17, Nick wrote: > Thanks Richard, I updated my users.txt file to include quotes (it > didn't) which fixed the broken auth file error, but now im getting > this... > > 1518 ERROR unconfigured_file: No such file or directory [...] If you are on a system with strace, try