Re: [GENERAL] [SQL] Encrypted column

I need to store users and passwords on a table and I want to store it encrypted, but I don't found documentation about it, how can I create a Take a look at the pgcrypto user-contributed module. -- Gary Chambers // Nothing fancy and nothing Microsoft! ---(e

Re: [GENERAL] Automated Database Backups

ckup owner's home directory: *:5432:*:postgres:MyPassword *:5432:*:xxxx:XsPassword -- Gary Chambers -- 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] Updates, deletes and inserts are very slow. What can I do make them bearable?

http://tinyurl.com/2fsjmv4 -- Gary Chambers /* Nothing fancy and nothing Microsoft! */ -- 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] Solaris install - "cannot compute sizeof (off_t)" error - readline issue?

tandard/include -L/your/non-standard/lib -R/your/non-standard/lib ..." \ ./configure ... -- Gary Chambers /* Nothing fancy and nothing Microsoft! */ -- 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] Schema tool

Marc, > may schemaspy help you ? > http://schemaspy.sourceforge.net/sample/relationships.html Thank you *VERY* much for suggesting this tool! -- Gary Chambers /* Nothing fancy and nothing Microsoft! */ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chan

Re: [GENERAL] Grant command help -- postgres

ecuting: pg_restore -U postgres -n blah -d db yourdumpfile.dmp This is predicated on having executed pg_dump with the -Fc (custom format) option. I haven't tested it with an text dump file. -- Gary Chambers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Tool for data modeling and ER diagram

t/) be added to the list. -- Gary Chambers /* Nothing fancy and nothing Microsoft! */ -- 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] Help with trigger

- 2012-04-27 00:00:00 | (1 row) With the exception of abbreviating the table (t) and column names (d1 and d2), your example as submitted works for me (8.4.5, MacOSX). What version of Pg are you using and on which platform? -- Gary Chambers -- Sent via pgsql-general mailing list (pgsql-general@post

Re: [GENERAL] Help with trigger

ORE INSERT OR UPDATE ON t FOR EACH ROW EXECUTE PROCEDURE t_listing_startdate(); -- Gary Chambers -- 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] Concatenating several rows with a semicolon

Alex, create or replace function pref_money_stats(_id varchar) returns varchar as $BODY$ begin declare stats varchar; for row in select yw, money from pref_money where id=_id order by yw desc limit 20 loop stats := stats || ";" || row.id || ":" || row

Re: [GENERAL] pg_dump and database size question

additional overhead is related to it being a text-based dump file. -- Gary Chambers -- 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] Inconsistent time interval formatting

. -- Gary Chambers -- 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] iPad and Postgresql...

vironments whether in Solaris or Linux. Pointers to the apps if you please :) Search for postgres or postgresql in the iTunes store. DataGlass PostgreSQL is one of the apps. I recall seeing another one a couple weeks back, but I can't remember the name of it at the moment. -- Gary Chambe

Re: [GENERAL] iPad and Postgresql...

iding with the Apple apachectl script), I symlink /opt/local/apache2/bin/apachectl -> /usr/local/bin/apache2ctl. -- Gary Chambers -- 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] Moving from SQL Anywhere to PostGres - First Time

I recommend dbWrench as a diagramming tool for Postgres. I can also recommend SchemaSpy (http://schemaspy.sourceforge.net/), a superb command line-based schema browser and ERD generator. -- Gary Chambers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Database Design Question

Forget separate databases. Use separate users with schemas. for canned applications like mediawiki and phpbb? not sure they support that. Mediawiki does -- I'm doing just that. It's been liberating learning how PostgreSQL deals with schemas (and applying that knowledge). -- Gar

Re: [GENERAL] Custom install options via apt-get install on ubuntu

u-specific command that will assist in creating and managing multiple clusters on an Ubuntu system. You may also be interested in pg_ctlcluster, pg_lsclusters, and pg_dropcluster. -- Gary Chambers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your su

Re: [GENERAL] Fwd: Web Hosting support for pgsql in PHP

Jeff, Via my post here, I am wondering what others are doing for hosting options that include both wordpress & php-pgsql If shared hosting is acceptable for your databases, have you considered a VPS? -- G. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make change

Re: [GENERAL] High Level Committers Wanted

Columbia the country or the District? There's also the river... And South Carolina... -- G. -- 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] securing the sql server ?

so when this remote server reboots, where does the encryption key come from? Why, from a file that resides in /root on the server, of course! :-) That's secure, right? -- Gary Chambers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

Re: [GENERAL] Split_part on a CR

Jeff, I'm having a hard time figuring out how to use split_part with a carriage return (hex 0a) as the delimiter. Would someone please offer me a clue? 0x0a is actually a new line. This works for me: select split_part(text_column, E'\n', 1) from table; -- GC -- Sent via pgsql-general mail

Re: [GENERAL] timezone, how postgres deal with it?

This query returns false select ('2012-11-20 17:00:00-02:00'::timestamp with time zone) = ('2012-11-20 18:00:00-03:00'::timestamp with time zone) It's false for me, too. Change '2012-11-20 18:00:00-03:00' to the correct '2012-11-20 16:00:00-03:00' and it will work as you expect. -- G. -- S

[GENERAL] Data Model Advice

;, 'g'); ELSE NEW.partno := REGEXP_REPLACE(NEW.partno_raw, E'(\\W|_)', '', 'g'); END IF; RETURN NEW; END; $fixup_partnumbers$ LANGUAGE plpgsql; Thank you in advance for any advice and assistance you can provide. -- Gary Chambers -- Se

[GENERAL] Data Model Advice

#x27;(\\W|_)', '', 'g'); ELSE NEW.partno := REGEXP_REPLACE(NEW.partno_raw, E'(\\W|_)', '', 'g'); END IF; RETURN NEW; END; $fixup_partnumbers$ LANGUAGE plpgsql; Thank you in advance for any advice and assistance you ca

Re: [GENERAL] Need magic for identifieing double adresses

to increase the odds of detecting duplicates is to trim each column, remove all internal whitespace, coalesce it into a single string, and calculate an MD5 (some other hash function may be better) hash. It's not perfect (we are dealing with humans, after all), but it helps. -- Gary Chambers

[GENERAL] Warning: you don't own a lock of type ExclusiveLock

select user_write_unlock(), which is a simple wrapper query that calls pg_advisory_unlock(). What are the causes and possible problems and side-effects of receiving such a log warning? Thank you for any assistance you can provide. -- Gary Chambers -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Warning: you don't own a lock of type ExclusiveLock

obtain an ExclusiveLock) due to VM "disk" residing on an NFS mount? -- Gary Chambers -- 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] Warning: you don't own a lock of type ExclusiveLock

it requested it. Thank you again for your reply! -- Gary Chambers -- 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] what Linux to run

Note that Ubuntu also comes in a GUI free server edition as well. I can definitely state that Ubuntu 10.04 LTS Server edition is rock solid stable +1 I've been running 10.04 LTS Server for over three years (on a Dell PowerEdge 2850) using Martin Pitt's PostgreSQL 9.1 PPA. -- Gar

Re: [GENERAL] what Linux to run

I've been running 10.04 LTS Server for over three years (on a Dell PowerEdge 2850) using Martin Pitt's PostgreSQL 9.1 PPA. I apologize. That's over two years. -- G. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresq

Re: [GENERAL] Fixing the loss of 'template1'

all will resume functioning as you expect. -- Gary Chambers -- 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] Fixing the loss of 'template1'

concerned, there is no problem with removing the template1 or postgres databases. That is not (or may not be) the case for some utilities and Linux distributions out there that expect them to exist where used as defaults. I haven't yet tried removing template0. -- Gary Chambers -- Sent vi

Re: [GENERAL] Is it even possible?

niversally abandoning Windows? You are not alone -- and I thought I felt strongly about it. :) -- Gary Chambers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] \copy Variable Substitution in 9.1.2

pply to the \copy command. In particular, the variable substitution rules and backslash escapes do not apply. Thanks for any suggestions. -- Gary Chambers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general