Marc G. Fournier wrote:
Stupid question, but what does MySQL bring to the equation? Why not
just use PostgreSQL in the first place?
Simplicity. A huge user base. No one is questioning that pg is a
superior product :)
http://www.mysql.com/why-mysql/marketshare/ *
*with a pinch of salt
See the archived thread here:
http://www.postgresql.org/message-id/CAEghcWD8DXjroBYCZsdGrx+cHTCbCbW9es2uQ+o7a8NZ61JT=q...@mail.gmail.com
Short version: Sorry, but you're going to need to recompile if you want
that behavior. Here's a diff applied against 9.2.1
http://pastebin.com/5AyaX2RF. I've dep
Sorry, but from what I understand the change is permanent. If recompile is
not an option but you're on Windows let me know; I do have binaries
available..
On Wed, Feb 6, 2013 at 2:05 PM, Igor Neyman wrote:
> Terence,
>
> ** **
>
> Thanks for quick reply, I read yo
t zlib (and the speed increase is quite significant).
T.J.
On Wed, Feb 6, 2013 at 3:23 PM, Igor Neyman wrote:
> I am on Windows (both 32 and 64 bit) using 32-bit Postgres.
>
> So, your binaries are for 9.2.1, you aren’t planning to go to 9.2.2?
>
> ** **
>
&g
x27;ve
only got clients in North America at the moment). You will undoubtedly need
to make some modifications to patch with 9.3, but I've got hundreds of 9.2
instances in the field now that, well, just work.
*Terence J. Ferraro*
On Wed, Feb 19, 2014 at 5:10 PM, Andrew Sullivan wrote:
>
You mentioned you are using the Windows version; unless something has
changed recently in their build process, the included openssl library is
not linked against zlib and therefore compression is not possible unless
you recompile the Windows version yourself.
*Terence J. Ferraro*
On Thu, May 8
We recently began upgrading our clients' servers from 9.0 -> 9.2. After a
few deployments and a little digging we noticed that 9.0 -> 9.1 broke the
use of no timezone set within postgresql.conf. That is, not setting the
option was now defaulting to GMT instead of the system timezone.
Unfortunately,
configuration
option, in this case, *then* assumes GMT.
In other words, it may be 2 AM NZST, but would you really want to walk
around and have all of your clocks read 1 PM (GMT)? :)
T.J.
On Sat, Dec 15, 2012 at 10:35 PM, Gavin Flower <
gavinflo...@archidevsys.co.nz> wrote:
> On 16/12/12 16:07
On Sat, Dec 15, 2012 at 11:54 PM, Gavin Flower <
gavinflo...@archidevsys.co.nz> wrote:
> Please do not top post, see end of email for rest of reply...
> (Bottom posting is the convention here, so people can see the context
> before reading your reply.)
>
>
>
> On 16/1
On Sun, Dec 16, 2012 at 1:16 PM, Tom Lane wrote:
> Andres Freund writes:
> > On 2012-12-16 12:25:13 -0500, Tom Lane wrote:
> >> I'm still not sure what
> >> the OP actually wants to accomplish by moving the time of making the
> >> choice.
>
> > I guess he wants - and I have seen that before - to
t me offline. My client would love to get some help from you on
administration/backup/restore stuff as an extra resource.
Can you image that I got my PostgreSQL setup and running in few hours. Cool!
Thanks! This mailling list is great! You people are great!
Terence Chang
---
ginal Message -
From: "scott.marlowe" <[EMAIL PROTECTED]>
To: "Terence Chang" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 17, 2003 7:35 AM
Subject: Re: [GENERAL] Where is the physical files of database that I just
> On Wed, 16 Jul 2
regards,
Terence
___
Do You Yahoo!?
Get your free @yahoo.com.hk address at http://mail.english.yahoo.com.hk
---(end of broadcast)---
TIP 7: don't forget to increase your free
a.firstname from app_v08.users a;
ERROR: No such attribute a.firstname
app=> select a.FIRSTNAME from app_v08.users a;
ERROR: No such attribute a.firstname
app=> select "A"."FIRSTNAME" FROM app_v08.users A;
ERROR: Relation "A" does not exist
app=> select "FIRS
This is exactly what I was doing. I use PostgreSQL Manager Pro. The tool
covert all my column name and table name in the double quote. So I have all
my column/table/function created in upper case (Oracle habit). Now, I have
to quote all of them.
I should stay with psql, I guess. :-)
Thanks! At le
Hi there:
I am just wondering if this is a doable method to
clone a database to other machine. I have three identical linux serves with
postgresql server installed at the same location. I have a new customized
database and initial data load into server 1. Can I just copy all of the
databas
16 matches
Mail list logo
