Hello and best wishes for this new year.
I have a question concerning the H2 DB.
http://www.h2database.com/html/main.html
I've read (on their site) that they got better perfs than PG or MySQL in
any case (embedded in a Java application and even as a standalone server).
Tests seem a bit light
Hello,
I am studying how to migrate our Production Database which is running
under PG 8.2 and we would like to move to PG 8.3
I have read that the only safe solution is to perform a dump and restore.
Our DB is around 6GB large.
I wanted to have an expectation of the migration duration and
... | psql ...
27 hours is in my opinion a little bit to much.
What is your hardware ?
Greetings,
-Franz
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Pascal Cohen
Gesendet: Freitag, 10. Oktober 2008 17:17
An: pgsql-general@postgresql.org
Hello
We are developing an application and would like to compute statistics on
it in order:
- to have a better understanding of what is used mostly in our
application to model at best our load test scenarios.
- to get information on the usage of the application for other departments.
The
Guillaume Lelarge wrote:
Pascal Cohen a écrit :
I had a look in previous posts in the forum but could not find the
answer I was looking for.
My question is should I switch from varchar to text.
We have discovered although it seems to be SQL that adding
something like 'text
Hello
I had a look in previous posts in the forum but could not find the
answer I was looking for.
My question is should I switch from varchar to text.
We have discovered although it seems to be SQL that adding something
like 'text ' to a varchar(50) just silently cut the text
Albe Laurenz wrote:
Pascal Cohen wrote:
I am playing with security in Postgres
And I would like to have a database that can be managed by a given user
that could do almost anything but I would also have a user that can just
handle what is created.
I mean she could insert, update delete
Hello
I am playing with security in Postgres
And I would like to have a database that can be managed by a given user
that could do almost anything but I would also have a user that can just
handle what is created.
I mean she could insert, update delete rows but not create tables.
I did not
Terry Lee Tucker wrote:
On Wednesday 23 April 2008 06:46, Pascal Cohen wrote:
Hello
I am playing with security in Postgres
And I would like to have a database that can be managed by a given user
that could do almost anything but I would also have a user that can just
handle what is created
Hello
We are using different OS (Mac, win (with a small w!) and Linux).
We had some problems when doing some ordering on names.
I found that it seemed to be related on locale, While on Linux it used
default locales (en_US.UTF-8 or something like that), I had a nice
behavior).
I learned to check
Hello
Are there users of PL/Java ?
I would like to get some feedback on using it.
As we could use triggers and as we have already some kinds of
'applicative' triggers written in Java, I was wondering if I could just
reuse the code and plug it
Thanks for any advice
On Fri, Nov 30, 2007 at 10:30:47PM +0100, Pascal Cohen wrote:
I am facing a probably very common problem. I made a search in the
recent archives and could find many posts related to my issue. But I did
not get exactly the answer to my question.
No, and I doubt you will.
I don't
On Mon, Dec 03, 2007 at 09:16:40AM +0100, Pascal Cohen wrote:
* For High-availability, I mainly studied PgPool and Log-shipping (and
in fact forgot Slony).
Until now I feel more comfortable with Log-shipping because it seems
safer (I am not sure I can't get some problems with sequences
Andrew Sullivan wrote:
On Mon, Dec 03, 2007 at 09:57:30AM +0100, Pascal Cohen wrote:
What kind of hardware solutions do you know ? - I will look on my own
what I can find.
Have a look at the discussion in the 8.3 manual, about shared disk and block
level replication:
http
Andrew Sullivan wrote:
On Mon, Dec 03, 2007 at 04:16:04PM +0100, Pascal Cohen wrote:
needs fast connections like fiber channels ? What is the impact on I/O
and general DB perfs ? - Sorry if my question is stupid - not an expert
on such things.
And I suppose it is not very cheap
By the way I found also another tool called CyberCluster that will
probably not make my choice easier ;)
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hello
I am facing a probably very common problem. I made a search in the
recent archives and could find many posts related to my issue. But I did
not get exactly the answer to my question.
How can I chose among the different existing tools to enable High
Availability and
17 matches
Mail list logo