Lists: | pgsql-general |
---|
From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | This whole MySQL versus PGSQL thing |
Date: | 2003-07-15 20:56:31 |
Message-ID: | Pine.LNX.4.33.0307151453210.28275-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
OK, so I thought I'd do some more checking.
MySQL is known for just swallowing what you give it and going on without
raising an exception. numeric is also one of them
SQL script in postgresql:
create table testa (i1 numeric (4,2), i2 numeric(4,2));
insert into testa values (100.23,99.34);
ERROR: overflow on numeric ABS(value) >= 10^2 for field with precision 4
scale 2
in mysql:
create table testa (i1 numeric (4,2), i2 numeric(4,2));
insert into testa values (100.23,99.34);
Query OK, 1 row affected (0.00 sec)
insert into testa values (10000.23,99.34);
Query OK, 1 row affected (0.00 sec)
insert into testa values (100000.23,99.34);
Query OK, 1 row affected (0.00 sec)
select * from testa;
+--------+-------+
| i1 | i2 |
+--------+-------+
| 100.23 | 99.34 |
| 999.99 | 99.34 |
| 999.99 | 99.34 |
| 999.99 | 99.34 |
+--------+-------+
4 rows in set (0.00 sec)
Hope you weren't basing any accounting systems on this database.
:-)
From: | "Terence Chang" <TChang(at)nqueue(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Where is the physical files of database that I just drop? |
Date: | 2003-07-16 22:57:32 |
Message-ID: | 009f01c34bed$a5354550$09f1e9a7@PEANUTLEN |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Hi there:
I am just wondering how to remove the files of the database I just drop. I
found there are whole bunch folders and files with number as the name. Once
I drop the database, how do I know which files I should delete manually?
Will the database engine delete that for me?
Thanks!
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Terence Chang" <TChang(at)nqueue(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Where is the physical files of database that I just drop? |
Date: | 2003-07-16 23:21:57 |
Message-ID: | 26007.1058397717@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
"Terence Chang" <TChang(at)nqueue(dot)com> writes:
> I am just wondering how to remove the files of the database I just drop. I
> found there are whole bunch folders and files with number as the name. Once
> I drop the database, how do I know which files I should delete manually?
Simple: none.
regards, tom lane
From: | "Terence Chang" <TChang(at)nqueue(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Where is the physical files of database that I just drop? |
Date: | 2003-07-16 23:27:48 |
Message-ID: | 00bb01c34bf1$e03e80e0$09f1e9a7@PEANUTLEN |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Great! That is easier than Oracle! Now! I have no excuse not to use
PostgreSQL. :-)
I got one more question! Is there a way that I can shut down only one
database for "Cold Backup" while other database are running like Oracle
does?
Thanks!
From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Terence Chang <TChang(at)nqueue(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Where is the physical files of database that I just |
Date: | 2003-07-16 23:39:01 |
Message-ID: | 3F15E215.9050900@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Terence Chang wrote:
> I got one more question! Is there a way that I can shut down only one
> database for "Cold Backup" while other database are running like Oracle
> does?
No, but then again, there is no need. pg_dump will give you a consistent
snapshot of the database as it was when you started the command. It is
essentially a "cold" backup that is taken while hot!
Joe
From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Terence Chang <TChang(at)nqueue(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Where is the physical files of database that I just |
Date: | 2003-07-17 14:35:32 |
Message-ID: | Pine.LNX.4.33.0307170834350.30557-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Wed, 16 Jul 2003, Terence Chang wrote:
> Great! That is easier than Oracle! Now! I have no excuse not to use
> PostgreSQL. :-)
>
> I got one more question! Is there a way that I can shut down only one
> database for "Cold Backup" while other database are running like Oracle
> does?
There's really no need to shut down and do a cold backup. pg_backup backs
up databases hot as if they were cold (i.e. it uses a snapshot system).
So, if you connect and start pg_dump, and 20 users initiate transactions
after that, you see none of those later transactions or any part of them
in your backup.
From: | "Terence Chang" <TChang(at)nqueue(dot)com> |
---|---|
To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Where is the physical files of database that I just |
Date: | 2003-07-17 15:11:48 |
Message-ID: | 003e01c34c75$c12ca900$0100a8c0@WINDOWS2000 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
IC.. However, my application is critical. So is it possible to backup those
20 user's transactions from log? Oracle and MS SQL can recover to the
failure point. Does PostgreSQL support that also? I mean recover from a
transaction log and where is the transaction log?
Thanks!
----- Original Message -----
From: "scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "Terence Chang" <TChang(at)nqueue(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
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 2003, Terence Chang wrote:
>
> > Great! That is easier than Oracle! Now! I have no excuse not to use
> > PostgreSQL. :-)
> >
> > I got one more question! Is there a way that I can shut down only one
> > database for "Cold Backup" while other database are running like Oracle
> > does?
>
> There's really no need to shut down and do a cold backup. pg_backup backs
> up databases hot as if they were cold (i.e. it uses a snapshot system).
> So, if you connect and start pg_dump, and 20 users initiate transactions
> after that, you see none of those later transactions or any part of them
> in your backup.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
From: | Doug McNaught <doug(at)mcnaught(dot)org> |
---|---|
To: | "Terence Chang" <TChang(at)nqueue(dot)com> |
Cc: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Where is the physical files of database that I just |
Date: | 2003-07-17 15:22:14 |
Message-ID: | m3isq141qx.fsf@varsoon.wireboard.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
"Terence Chang" <TChang(at)nqueue(dot)com> writes:
> IC.. However, my application is critical. So is it possible to backup those
> 20 user's transactions from log? Oracle and MS SQL can recover to the
> failure point. Does PostgreSQL support that also? I mean recover from a
> transaction log and where is the transaction log?
Not yet. A lot of people have asked for that. The feature is being
actively worked on but will not be in the upcoming 7.4 release.
There's a good chance it will be in 7.5 (or whatever the release after
that is called).
-Doug