Karthikeyan Sundaram wrote:
Hi Scott,
Thanks for replying. The tablespace is not the main problem here. I
want the data files to grow in the new partition along with the old
linux partition.
Let me put like this.
We have a linux partition of 120GB called as
/local/postgres/databas
Hej!
After a years break I am looking at Mambo/Joomla CMS for a couple of non
mission critical projects. I really don't want to run MySQL behind these
sites (did I say i don't like MySQL? =:-D) and was pleased to discover
that someone was working on a project to put a compatibility layer
between s
Hello,
I'd like to know which solutions exist encrypt postgresql database ?
Did you already use an encryption method ?
I saw on the web that there is a contrib (pgcypto) but I can't estimate
its efficiency
Olivier
begin:vcard
fn:Olivier Boissard
n:Boissard;Olivier
org:Cerene Services
adr:;;3
Στις Τετάρτη 07 Φεβρουάριος 2007 02:15, ο/η Andrew Hammond έγραψε:
> I'm looking for a document on best practices for building and
> operating PostgreSQL on FreeBSD (amd64). Does such a thing already
> exist? If not, I'm willing to put one together and maintain it.
>
> Things I care about:
> 1) I n
On Wed, Feb 07, 2007 at 11:23:03AM +0100, Olivier Boissard wrote:
> I saw on the web that there is a contrib (pgcypto) but I can't estimate
> its efficiency
Well, it works for some people. What are you trying to accomplish
with "database encryption"?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Στις Τετάρτη 07 Φεβρουάριος 2007 16:31, ο/η Achilleas Mantzios έγραψε:
> Στις Τετάρτη 07 Φεβρουάριος 2007 02:15, ο/η Andrew Hammond έγραψε:
> > I'm looking for a document on best practices for building and
> > operating PostgreSQL on FreeBSD (amd64). Does such a thing already
> > exist? If not, I'm
On Mittwoch, 7. Februar 2007 09:45 Tony Grant wrote:
> Have any of you tested this under moderate load? If yes what issues
> need I watch out for?
No, but if you receive some answer, I'd be interested also - for the
same "no mysql" reason :-)
mfg zmi
--
// Michael Monnerie, Ing.BSc-
Hi,
Sorry for my question, but what's the feature on Oracle like tsearch?
Can we consider a good difference PG under Oracle?
Of course, PG we can developer our own application in any language.
But, talking about text search, does Oracle has a similar feature?
Thanks
___
On 2/7/07, Alexander B. <[EMAIL PROTECTED]> wrote:
Sorry for my question, but what's the feature on Oracle like tsearch?
Can we consider a good difference PG under Oracle?
Of course, PG we can developer our own application in any language.
But, talking about text search, does Oracle has a simil
Tony Grant wrote:
> Hej!
>
> After a years break I am looking at Mambo/Joomla CMS for a couple of non
> mission critical projects. I really don't want to run MySQL behind these
> sites (did I say i don't like MySQL? =:-D) and was pleased to discover
> that someone was working on a project to put a
I've got a particular sql statement I'm trying to work out that seems to be
taking far too long to run. I've been told that there's supposed to be some
kind of timing command to record how long a statement runs for, but I'm having
trouble figuring it out. The textbook I'm working with, Postgre
On Wed, Feb 07, 2007 at 09:00:32AM -0800, Andrew Edson wrote:
> What is the command I should be looking for to measure the
> runtime on my statements?
In psql, use \timing.
In your postgresql.conf file, you can set
log_min_duration_statement=0.
You can also use EXPLAIN ANALYSE to see the f
Le mercredi 07 février 2007 à 08:50 -0800, Joshua D. Drake a écrit :
> > Of course a CMS that is database
> > agnostic would be the ideal sollution...
>
> Drupal?
Yes of course but, well, not so serious a CMS =:-D
Tony
--
---(end of broadcast)---
Tony Grant wrote:
> Le mercredi 07 février 2007 à 08:50 -0800, Joshua D. Drake a écrit :
>
>>> Of course a CMS that is database
>>> agnostic would be the ideal sollution...
>> Drupal?
>
> Yes of course but, well, not so serious a CMS =:-D
It can be argued that no serious cms would use MySQL.
J
On Dienstag, 6. Februar 2007 08:46 Achilleas Mantzios wrote:
> Thats what i mean, postmaster is alive, and accepting connections
> during the above command, so what would prevent a 2nd client (from
> your mail server setup most likely)
> from inserting a value that is later present in the dump,
> w
Hi,
I don't want to compare with Oracle and postgres. But I have a situation.
I am using psql command line tool supplied by postgres.
In Oracle I can say
select * from emp where emp_id = &1
Oracle will ask:
Enter a value for 1:
If I enter 10, then Oracle will get the empid=10
On 2/7/07, Ezequiel Luis Pellettieri <[EMAIL PROTECTED]> wrote:
thanks guys, is it possible to go with it, without stopping the postmaster?
maybe just rejecting conns to the DB...
this is cos I had another DB's running...
thanks again.
AFAIR, no
--
regards,
Jaime Casanova
"Programming today
On 2/7/07, Karthikeyan Sundaram <[EMAIL PROTECTED]> wrote:
I don't want to compare with Oracle and postgres. But I have a
situation.
I am using psql command line tool supplied by postgres.
In Oracle I can say
select * from emp where emp_id = &1
Oracle will ask:
Enter a value
thanks guys, is it possible to go with it, without stopping the postmaster?
maybe just rejecting conns to the DB...
this is cos I had another DB's running...
thanks again.
pelle.-
2007/2/6, Scott Marlowe <[EMAIL PROTECTED]>:
On Mon, 2007-02-05 at 21:03, Jaime Casanova wrote:
> > 2007/2/5, Mil
Hi All,
What are the reasons of data getting fragmented in postgres? Do we have any
page which explains different scenarios of data getting fragmented?
Regards,
Moiz Kothari
In Oracle there is something similar to tsearch2. It's called as Oracle
Text.
I vaguely remember the syntax.
In Oracle.
Select * from table where contains column = (text search)
Regards
skarthi
From: "Alexander B." <[EMAIL PROTECTED]>
To: "pgsql-admin@postgresql.org"
Subject: [ADMIN] tsear
here is the link on oracle text
http://www.oracle.com/technology/products/text/index.html
From: "Alexander B." <[EMAIL PROTECTED]>
To: "pgsql-admin@postgresql.org"
Subject: [ADMIN] tsearch feature
Date: Wed, 07 Feb 2007 14:27:48 -0200
Hi,
Sorry for my question, but what's the feature on Ora
Στις Πέμπτη 08 Φεβρουάριος 2007 00:07, ο/η Michael Monnerie έγραψε:
>
> But I'd like to suggest changing the ERROR to WARNING for "duplicate key
> violates unique constraint", as it's not serious - but it sounds like a
> big problem.
>
I dont think that would be appropriate. Attempt to violate a UN
24 matches
Mail list logo
