Hi,
I have the need to encrypt some columns in some tables. With Postgres 7.4,
using a tablespace on an encrypted partition is not an option, right?
Furthermore, the content would be contained unencrypted in any database
dump.
Thus, my idea is:
- put the encryption/decryption key in a temporary
Chris Travers <[EMAIL PROTECTED]> writes:
> Luki Rustianto wrote:
>> I wonder if there are any guidelines / step by step / special
>> considerations whether it applies to database structure or the
>> application it self if we want to upgrade to version 8.xxx ?
> Depends on if your app depends on t
thank!
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Chris wrote:
Of course. Shameless plug coming up ;)
http://www.designmagick.com/category/2/Starting-Out
Thanks ^_^
--
Rory Hart
Lifestyle Management Consultant
Professional Lifestyle Management
http://www.lifestylemanage.com
Phone 03 9879 5643 PO Box 4179
Fax03 9879 67
Rory Hart wrote:
Chris wrote:
Rory Hart wrote:
Hi,
I'm wanting to build a database and interface for a small business to
keep track of things such as clients, suppliers etc. The database
will be served on a Linux box, with users accessing/updating it over
the network from both Linux and w
Chris wrote:
Rory Hart wrote:
Hi,
I'm wanting to build a database and interface for a small business to
keep track of things such as clients, suppliers etc. The database
will be served on a Linux box, with users accessing/updating it over
the network from both Linux and windows.
I'm wond
Rory Hart wrote:
Hi,
I'm wanting to build a database and interface for a small business to
keep track of things such as clients, suppliers etc. The database will
be served on a Linux box, with users accessing/updating it over the
network from both Linux and windows.
I'm wondering if I could
Hi,
I'm wanting to build a database and interface for a small business to
keep track of things such as clients, suppliers etc. The database will
be served on a Linux box, with users accessing/updating it over the
network from both Linux and windows.
I'm wondering if I could get some suggesti
Luki Rustianto wrote:
Hi All,
All of our application now runs on postgresql7.4.xxx servers, I never
tried it on version 8.xxx
I wonder if there are any guidelines / step by step / special
considerations whether it applies to database structure or the
application it self if we want to upgrade t
Hi All,
All of our application now runs on postgresql7.4.xxx servers, I never
tried it on version 8.xxx
I wonder if there are any guidelines / step by step / special
considerations whether it applies to database structure or the
application it self if we want to upgrade to version 8.xxx ?
Thanks
On Tuesday 28 March 2006 17:31, Jim C. Nasby wrote:
> On Wed, Mar 29, 2006 at 12:24:04AM +0200, SunWuKung wrote:
> > In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> > > On Tue, Mar 28, 2006 at 09:28:12PM +0200, SunWuKung wrote:
> > > > This is going to be an amateur question...
> > > >
> > > >
On Tue, 2006-03-28 at 19:01, Antimon wrote:
> Hi,
> I was testing MySQL and PgSQL performances on my home box (amd athlon
> 64 3000, 1gig ddr ram, sata I hdd, win xp (x86)), select and insert
> times seeemed identical with innoDB.
>
> But when i try to query both using php, there's a huge differen
Try factoring the connect time out of the test. My experience is the
connect is more expensive for Postgres than MySQL. With that out of the
way, I'd wager the times will be closer.
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Antimon
S
On Tue, Mar 28, 2006 at 05:01:45PM -0800, Antimon wrote:
> $pdo = new PDO('pgsql:host=localhost;dbname=test', "testacc", "pw");
> for ($i = 0; $i < 1; $i++)
> {
> $result = $pdo->query("Select "+$i);
> }
> output is:
> 2.7696590423584
Ok, so that tells me that on this plain-vanilla hardw
Hi,
I was testing MySQL and PgSQL performances on my home box (amd athlon
64 3000, 1gig ddr ram, sata I hdd, win xp (x86)), select and insert
times seeemed identical with innoDB.
But when i try to query both using php, there's a huge difference even
for a funny query like "select 1"
Here's the co
On Tue, 2006-03-28 at 16:24, SunWuKung wrote:
> In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> says...
> > On Tue, Mar 28, 2006 at 09:28:12PM +0200, SunWuKung wrote:
> > > This is going to be an amateur question...
> > >
> > > Could somebody explain me, or point me to a resource where I can
On Wed, Mar 29, 2006 at 12:24:04AM +0200, SunWuKung wrote:
> In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> says...
> > On Tue, Mar 28, 2006 at 09:28:12PM +0200, SunWuKung wrote:
> > > This is going to be an amateur question...
> > >
> > > Could somebody explain me, or point me to a resource
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
says...
> On Tue, Mar 28, 2006 at 09:28:12PM +0200, SunWuKung wrote:
> > This is going to be an amateur question...
> >
> > Could somebody explain me, or point me to a resource where I can find
> > out what is the recommended practice when a live
[EMAIL PROTECTED] writes:
> Yes, that's what I'm looking for. How can I create an IMPLICIT
> cast from date to my custom type? IOW, if I assing a date to a
> varible of my type, it will be converted to the format I specify.
Make a function that does the conversion the way you want, and then
crea
On Tue, Mar 28, 2006 at 09:28:12PM +0200, SunWuKung wrote:
> This is going to be an amateur question...
>
> Could somebody explain me, or point me to a resource where I can find
> out what is the recommended practice when a live db needs to be replaced
> with a new version of it that has a sligh
Scott Marlowe <[EMAIL PROTECTED]> writes:
> On Tue, 2006-03-28 at 13:14, Jim C. Nasby wrote:
>> Tom has mentioned in the past that he's been backpatching stuff to 7.3
>> as part of his job, so I would assume that RH will support any 7.3
>> version.
> But only for supported OSes. I'm pretty sure 2
On Tue, 2006-03-28 at 13:14, Jim C. Nasby wrote:
> On Mon, Mar 27, 2006 at 10:03:27AM -0800, Leon Pu wrote:
> > do you mean PostgreSQL 7.3 is supported by RedHat on Advanced Server
> > 2.1?
> >
> > I only found PostgreSQL 7.1.3's rpms for RedHat Advanced Server 2.1, no
> > newer version anymore.
>
On Mon, Mar 27, 2006 at 10:03:27AM -0800, Leon Pu wrote:
> do you mean PostgreSQL 7.3 is supported by RedHat on Advanced Server
> 2.1?
>
> I only found PostgreSQL 7.1.3's rpms for RedHat Advanced Server 2.1, no
> newer version anymore.
Tom has mentioned in the past that he's been backpatching st
> Does anybody know good comparison/review article of XML support in
> major RDMBSes? I know that PostgreSQL's XML capabilities are quite
> weak, but how far is it from other products?
Could you please desribe a specific example of what you would like to
do and how you would not be able to do that
On Tue, Mar 28, 2006 at 03:34:18PM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > but that syntax doesn't work. I thought I might be able to create
> > my own type, and have an implicit conversion of DATE,
>
> You can *make* an implicit cast from (or to) DATE, but there won't be
> one mad
SunWuKing.
> Could somebody explain me, or point me to a resource where I can find
> out what is the recommended practice when a live db needs to be replaced
> with a new version of it that has a slightly different structure?
Put the new database on a development machine.
Do a dump of the o
[EMAIL PROTECTED] writes:
> but that syntax doesn't work. I thought I might be able to create
> my own type, and have an implicit conversion of DATE,
You can *make* an implicit cast from (or to) DATE, but there won't be
one made for you.
regards, tom lane
---
This is going to be an amateur question...
Could somebody explain me, or point me to a resource where I can find
out what is the recommended practice when a live db needs to be replaced
with a new version of it that has a slightly different structure?
My first guess would be to create the empty
ANSI has declared that the official pronunciation for SQL is /ɛs kjuː ɛl/
Klint Gore wrote:
Who's "they"? The only datbase vendor I've heard call their own product
"sequel" is MS.
SEQUEL (pronounced sequel) was a predecessor to SQL in IBM's 1970's
System R database; but isn't really the sa
Many of my tables have a timestamp column, which I store as
TIMESTAMP WITH TIME ZONE. Often I only want to return the date from
this field, and it may need a specific format.
All of the queries are passed through PLpqsql functions that return
either a record or a set of records. I find if I d
On Sat, 2006-25-03 at 10:11 -0800, Chris Travers wrote:
> Leif Jensen wrote:
>
> > Hello,
> >
> > I have with great interrest been following this thread. We have a
> >(small) flame war in house about this and I'm very happy about all the
> >arguments I have seen. I'm a long time user of Postgre
On Sunday March 26 2006 9:14 am, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > With our set of 4 DBs, that amounts to once every 40 minutes
> > for the given database. I see "LOG: autovacuum: processing
> > database "xyz"" in the log, but I do not see any
> > analyze/vacuum commands b
On Tue, 28 Mar 2006 12:14:28 +1000 Klint Gore <[EMAIL PROTECTED]> wrote:
>
> On Tue, 28 Mar 2006 10:10:15 +0930 (CST), Michael Talbot-Wilson <[EMAIL
> PROTECTED]> wrote:
> > How, really, do people pronounce PostgreSQL?
>
> we just use postgres.
Post Gress is what I've heard also.
>
> > They
On Mon, 2006-03-27 at 11:04, Stefan Fink wrote:
> Hi all,
>
> I would like to create a database based upon a template which also
> contains some tables. After invoking
>
> psql -T -U -O test
>
> the new database 'test' belongs to but all tables are still
> belonging to the user who owns the
Gavin Hamill <[EMAIL PROTECTED]> writes:
> Having successfully got pg 8.1.3 to run, I'm simply trying to pg_restore
> a dump from our live server. However, even very soon into the restore, I
> get these messages from the autovacuum daemon once per minute:
> 2006-03-28 14:15:35 BSTERROR: out of m
On Mar 28, 2006, at 4:47 AM, surabhi.ahuja wrote:However those application will be running with the 64-bit installed postgres server.They speak to each other via TCP/IP protocol which is CPU independent. so yes, it will work (and does work).
Richard Broersma Jr scrisse in data 03/28/06 15:18:
No it isn't. But I remember reading on one of the lists that it was on the to-do list for 8.2.
However, I do not know how high it is on the list of things to do. So I imagine that there is the
potential that it might not be added.
I'll wai
Dick Kniep <[EMAIL PROTECTED]> writes:
> Now when I try to access the tables/views in the schema as a user that
> is NOT a member of the group adeuxproductie, I expect it to
> fail. However, access is granted as if there is no authorization
> specified.
Perhaps you tested this as a superuser? For
Gavin Hamill wrote:
Having successfully got pg 8.1.3 to run, I'm simply trying to pg_restore
a dump from our live server. However, even very soon into the restore, I
get these messages from the autovacuum daemon once per minute:
[...]
2006-03-28 14:15:35 BSTERROR: out of memory
2006-03-28 14:
Tom
Dont think its large file support, I'm running on FC4, the problem existed on
FC1 too.
I'll try the custom format and see if that helps. Thanks for the
recommendation.
-bill
On Mon, March 27, 2006 4:35 pm, Tom Lane said:
> "beer" <[EMAIL PROTECTED]> writes:
>> We have a medium sized data
On Mon, 27 Mar 2006 07:31:36 -0600, Jim C. Nasby wrote:
> On Mon, Mar 27, 2006 at 05:22:40PM +0400, Ivan Zolotukhin wrote:
>> Hello,
>>
>> Does anybody know good comparison/review article of XML support in major
>> RDMBSes? I know that PostgreSQL's XML capabilities are quite weak, but
>> how far
[ Oops, I missed the reply-to button the first time - sorry for the
repeat, Csaba ]
On 3/28/06, Csaba Nagy <[EMAIL PROTECTED]> wrote:
> > Try breaking down the A query with LIMIT/OFFSET so that it never holds
> > locks for long. That way B will not wait for long, if at all, and will
> > not fail.
Michael Talbot-Wilson wrote:
How, really, do people pronounce PostgreSQL?
http://www.serioustechnology.com/postgres.ogg
Or for those of you who have an inferior operating system:
http://www.serioustechnology.com/postgres.wav
--
Until later, Geoffrey
Any society that would give up a little l
On 3/28/06, Alex Turner <[EMAIL PROTECTED]> wrote:
> The solution that I have seen typical is to have both webserver and database
> machine behind a firewall both NATed, with only HTTP and HTTPS ports open on
> the webserver. SSH is not open, as trusted clients connect via the VPN in
> the firewal
> Try breaking down the A query with LIMIT/OFFSET so that it never holds
> locks for long. That way B will not wait for long, if at all, and will
> not fail.
Just as a remark, this will only work if the chunks can be processed in
separate transactions. If the whole thing is related and A must be
c
On Tue, 2006-03-28 at 14:56 +0200, David Welton wrote:
> There are two processes, A, and B.
>
> A is a daemon process that performs a select, and then slowly iterates
> over the results, performing updates along the way.
>
> It is possible that interactive process B comes along, and wants to
> c
On Tue, Mar 28, 2006 at 02:58:45PM +0200, Gevik Babakhani wrote:
> Hello Folks,
>
> I would like to know if deleting functions from pg_catalog.pg_proc with
> the following SQL statement is advisable?
Offhand I think you're going to run into problem like the dependancies
not being removed which co
> Jebus scrisse in data 03/27/06 19:03:
>
> >I could be wrong but primary keys and other constraints are not inherited.
do you know if
> this problem is solved in postgres 8.1?
No it isn't. But I remember reading on one of the lists that it was on the
to-do list for 8.2.
However, I do not kno
Having successfully got pg 8.1.3 to run, I'm simply trying to pg_restore
a dump from our live server. However, even very soon into the restore, I
get these messages from the autovacuum daemon once per minute:
2006-03-28 14:15:35 BSTLOG: autovacuum: processing database "laterooms"
TopMemoryCont
Thank you ver much for you responase.
Yes, I had to change the client encoding for Postgres 8.1 (I had
forgotten) to Latin1 because of a client encoding mismatch error while
using the ODBC drivers on Windows. Stupid of me. Sorry for the bother -
I changed the client encoding to UTF8 and it wor
Hello Folks,
I would like to know if deleting functions from pg_catalog.pg_proc with
the following SQL statement is advisable?
I would like a way of deleting my functions without using the DROP
FUNCTION statement.
--
delete from pg_
Hi,
I'm trying to figure out the best way to handle the following situation.
There are two processes, A, and B.
A is a daemon process that performs a select, and then slowly iterates
over the results, performing updates along the way.
It is possible that interactive process B comes along, and w
OK, thx...
27. března 2006, 14:51:26, napsal jste:
JCN> On Sun, Mar 26, 2006 at 08:30:44PM +0200, David Hoksza wrote:
>> Hi, I would like to know, when ambulkdelete is run. I thought that
>> when tuple is deleted so bulkdelete is run, but when I set breakpoint
>>
hi all
please tell if it is possible to
Run your 32-bit applications against the 64-bit installed postgres
server.
I am using postgres 8.0.0 and for building my application i use the 32 bit
postgres server.
However those application will be running with the 64-bit installed postgres
server.
w
On Tuesday 28 March 2006 10:05, Martijn van Oosterhout wrote:
> That's because it's decribed in the SQL standard. UNION ALL just joins
> the results of the two queries. UNION removes duplicates which usually
> means sorting and comparing the tuples. UNION ALL is faster and usually
> what you want a
On Tue, Mar 28, 2006 at 09:45:02AM +0100, Ashley Moran wrote:
> On Monday 27 March 2006 12:13, Martijn van Oosterhout wrote:
> > You're using UNION rather than UNION ALL where. There's a big
> > difference and I imagine you actually want the latter. It also makes a
> > big difference in query optim
On Monday 27 March 2006 12:13, Martijn van Oosterhout wrote:
> You're using UNION rather than UNION ALL where. There's a big
> difference and I imagine you actually want the latter. It also makes a
> big difference in query optimisation.
>
> If that doesn't fix it, come back with the EXPLAIN ANALYZ
On Monday 27 March 2006 13:57, Jim C. Nasby wrote:
> BTW, you might also find inheritance to be of use:
> http://www.postgresql.org/docs/8.1/interactive/ddl-inherit.html
I'm not sure inheritance will help here or not. I need to aggregate all the
sub tables and add a field whose value depends on
Hi all,
I would like to create a database based upon a template which also
contains some tables. After invoking
psql -T -U -O test
the new database 'test' belongs to but all tables are still
belonging to the user who owns the template . This results
in the following error message when access
59 matches
Mail list logo
