Re: [GENERAL] How to Backup like in mysql or ms sql server
You can technically just copy & paste the postgresql data directory IF YOU SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for the same version of postgresql. Also: this is not a good way to do it and I'd encourage you not to use this as general means of backup (it's ok if you want to create a quick clone of an existing database on a second machine - provided that the platform and postgresql version on there is identical to the source). The proper way would be to use pg_dump (a tool that comes along every postgresql installation - see the docs for usage), which will dump the data and structure. There is a second such utility program called pg_restore which will take the dump-file created with pg_dump and restore it to a database of your choosing. Those dumps will be functional between versions and platforms - so that's the way to go. UC On Saturday 01 July 2006 21:01, Joko Siswanto wrote: > Hi all, > > I'm new bie in postgresql. > I use postgresql 8.1 windows version. > How to back-up database in postgresql? Usually i use pgAdmin III by back-up > and restore. > Is there any way to back-up database like mysql or sql server we just copy > and paste. Or maybe there is any tools to copy database when the service is > shutdown. > > Where is postgresql put teh database files? > > Thanks all, > Jokonet -- Open Source Solutions 4U, LLC 1618 Kelly St Phone: +1 707 568 3056 Santa Rosa, CA 95401 Cell: +1 650 302 2405 United States Fax:+1 707 568 6416 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] How to Backup like in mysql or ms sql server
On windows the database files are under C:\program files\postgresql\8.1 \data There are a number of different ways a backup can be done and a file level copy/paste is one of them. See http://www.postgresql.org/docs/8.1/interactive/backup.html Mike On Sun, 2006-07-02 at 11:01 +0700, Joko Siswanto wrote: > > > Hi all, > > I'm new bie in postgresql. > I use postgresql 8.1 windows version. > How to back-up database in postgresql? Usually i use pgAdmin III by > back-up and restore. > Is there any way to back-up database like mysql or sql server we just > copy and paste. Or maybe there is any tools to copy database when the > service is shutdown. > > Where is postgresql put teh database files? > > Thanks all, > Jokonet > > ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] How to Backup like in mysql or ms sql server
> I'm new bie in postgresql. > I use postgresql 8.1 windows version. > How to back-up database in postgresql? Usually i use pgAdmin III by back-up > and restore. > Is there any way to back-up database like mysql or sql server we just copy > and paste. Or maybe there is any tools to copy database when the service is > shutdown. > > Where is postgresql put teh database files? I am not sure about mysql or sql Server, but the following link will how how it is done on the command line of the PostgreSQL server: http://www.postgresql.org/docs/8.1/interactive/backup.html Is is a good place to start. Also, if you are interested in keeping your data backed up current within the last few minutes, check out point in time recovery (PITR). But for simple backup and restore, I expect that you will be satisfied with the simple pg_dump command. Regards, Richard Broersma Jr. ---(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
[GENERAL] How to Backup like in mysql or ms sql server
Hi all,I'm new bie in postgresql. I use postgresql 8.1 windows version.How to back-up database in postgresql? Usually i use pgAdmin III by back-up and restore. Is there any way to back-up database like mysql or sql server we just copy and paste. Or maybe there is any tools to copy database when the service is shutdown. Where is postgresql put teh database files?Thanks all,Jokonet
Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4
Hi Dave, Documentation such as this can be added to the new techdocs area on the main site at http://www.postgresql.org/docs/techdocs under the relevant section (probably http://www.postgresql.org/docs/techdocs.3 in this case). Please note that the editting interface is still new and may still have a quirk or two... Great, thank you for the pointer to the page. However, I think I have been bitten by one of the two quirks ;) I managed to get through editing and formatting of the document, but upon submission, it fails to accept the document, stating that several properties are invalid (errors at the bottom of this message). I did not add any custom formatting, and only used the features and controls available within the editing interface.. So, it seems at this time, that I'll have to wait to post this until the form is fixed, or possibly submit it in some other fashion.. Thank you to everyone else who offered corrections, also! I knew there would be a few, and I will incorporate them into the revision before final submission. Cheers, -Jason error output upon choosing 'Save' from the techdocs editor: --- Element H2: Invalid attribute "STYLE" Element U: Invalid element Element U: Invalid element Element DIV: Invalid attribute "STYLE" Element DIV: Invalid attribute "STYLE" Element DIV: Invalid attribute "STYLE" Element U: Invalid element Element LI: Invalid attribute "STYLE" Element U: Invalid element Element U: Invalid element Element U: Invalid element Element U: Invalid element Element U: Invalid element ---(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
Re: [GENERAL] pgsql vs mysql
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED]
("Merlin Moncure") transmitted:
> hm. that's all very true (and important), but I try and keep focus
> on the things besides basic correctness that drive the development
> cultural divide that seperates the two communities. pg, besides
> being a very project and surrounded by wonderful people, 'feels'
> right when solving problems. why does it feel right? what kinds of
> things in the database influence the development culture? pg
> satisfies me on a much deeper level that transcends feature 'x' or
> 'y' but stems from something much more vital and vibrant. it seems
> like the biggest brains who really 'get it' are here, and that's why
> I'm here.
One cultural divide is that MySQL development takes place inside one
private company, whereas PostgreSQL is developed by what truly is a
global community. That difference has a lot of side-effects.
One thing that doesn't quite stem directly from that is that there are
definitely some deep thinkers in the PostgreSQL community. And they
consistently think beyond the scope of any given immediate problem.
They don't just try to patch over some immediate issue; they try to
see if there's a further issue.
For instance, we recently (in the last year) had some challenges
compiling PostgreSQL on AIX, and reported as much. An "immediate"
resolution might have been to tweak the config script a little. What
we got instead was something of an audit of "weird libs still in use."
A number of build changes were made to assortedly remove now-obsolete
libs, and to have specific programs compile in only those libraries
that they actually need. We'll see, when 8.2 is getting deployed, if
this fully addresses our AIX issues; I expect it's close.
What was interesting was that not only was the fix completely
different from what was expected, but it became a more ambitious
change that cleans up things on a lot of platforms.
That seems not uncommon; someone comes, thinking they have The Answer
to something. Further examination shows that it wasn't the right
question, but someone figures out what that question should have been
:-).
--
(reverse (concatenate 'string "moc.liamg" "@" "enworbbc"))
http://linuxdatabases.info/info/internet.html
Een schip op het strand is een baken in zee.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Re: [GENERAL] pgsql vs mysql
On 6/30/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: Actually, PITR is in no way analagous. Try replicating something like 'INSERT INTO table SELECT random();' on MySQL and note how all the data is different. pgpool replication is equivalent to MySQL's replication. Or if you want more sophisticated replication, use Slony. i think you are missing the point here...mysql binary log replication is asynchronous and log based. it has some limitations and gotchas like you noted but feels a lot like the pg pitr mechanism. you get a lot of power and use for a relatively little administative overhead and an easy set up. you can almost, but not quite, do the same thing with pg pitr, although pitr is useful for a lot of other things. slony, of course, is quite sophisticated and powerful but fills a different need, i think. BTW, anyone curious about the differences should take a look at google:'mysql gotchas' (there's also a PostgreSQL section on that site). See also the MySQL/PostgreSQL thread that was on this list yesterday. hm. that's all very true (and important), but I try and keep focus on the things besides basic correctness that drive the development cultural divide that seperates the two communities. pg, besides being a very project and surrounded by wonderful people, 'feels' right when solving problems. why does it feel right? what kinds of things in the database influence the development culture? pg satisfies me on a much deeper level that transcends feature 'x' or 'y' but stems from something much more vital and vibrant. it seems like the biggest brains who really 'get it' are here, and that's why I'm here. merlin ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] different sort order in windows and linux version
"Tomi NA" <[EMAIL PROTECTED]> writes: > Basically, it comes down to three possibilities, doesn't it: > 1.) use an existing library > 2.) write a pgsql specific implementation > 3.) forget about it and tend to other issues > Personally, I don't really care if it's 1) or 2): I'm just afraid it's > going to be 3). > Is this a licencing issue (with regard to ICU beeing under the IBM > public licence)? Licensing is a concern --- IBM's appears to be not quite BSD enough. Size and portability of the library are concerns. Performance is a concern. Whether the patch makes the library required or optional is a concern (if required, the portability issue becomes a whole lot more urgent). Loss of existing functionality is a concern --- for instance, if the patch is such that UTF8 becomes the only supported server encoding, it'll probably be rejected forthwith. > A plugin architecture (to get rid of licencing headaches) issue? AFAIK making it a "plugin" won't alleviate anyone's licensing worries. Certainly that's not going to answer if the library is GPL. > To be perfectly honest, I've had to tackle so many problems with > encodings during the years I'd make it punishable by law to use > anything *but* UTF...but I'm not president of the Galaxy yet, Zaphod > is. (-: Well, the Japanese think that UTF8 is not the solution to all their worries, so they won't be happy with a UTF8-only solution. Likewise, those of us who only need single-byte character sets won't be very happy with being forced to accept multi-byte processing overhead. regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] different sort order in windows and linux version
On 7/1/06, Martijn van Oosterhout wrote: On Fri, Jun 30, 2006 at 07:29:12PM +0200, Tomi NA wrote: > If I sound harsh, please excuse me, but I feel like I'm the only one > who thinks these encoding problems (collation, upper/lowercase, > multiple languages in a single database) are serious...nobody seems to > share the sentiment. Ah well... I agree with you, however the resistance (AFAICS) comes mostly from the fact that we would be depending on an external library to do it. I don't think postgres should try doing it itself, given that the unicode character databases are quite large by themselves. Alternativly, the postgres group could produce a customised version of ICU that's smaller (the website has details about how). But any case, this problem will need to be addressed at some point. Basically, it comes down to three possibilities, doesn't it: 1.) use an existing library 2.) write a pgsql specific implementation 3.) forget about it and tend to other issues Personally, I don't really care if it's 1) or 2): I'm just afraid it's going to be 3). Is this a licencing issue (with regard to ICU beeing under the IBM public licence)? A plugin architecture (to get rid of licencing headaches) issue? Are there any other libraries that might do the job? To be perfectly honest, I've had to tackle so many problems with encodings during the years I'd make it punishable by law to use anything *but* UTF...but I'm not president of the Galaxy yet, Zaphod is. (-: t.n.a. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] Is there any way to index or cache a view, or function results?
Thanks that is basically what I was looking for I will investigate further. I appreciate your response. Thank you for your time, Jason Long CEO and Chief Software Engineer BS Physics, MS Chemical Engineering http://www.supernovasoftware.com HJBUG Founder and President http://www.hjbug.com -Original Message- From: Richard Broersma Jr [mailto:[EMAIL PROTECTED] Sent: Saturday, July 01, 2006 4:49 PM To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Subject: Re: [GENERAL] Is there any way to index or cache a view, or function results? > I was hoping for something a bit more automatic with less maintenance from > me. Thank you for your reply. > On 7/1/06, Jason Long <[EMAIL PROTECTED]> wrote: > > > > Is it possible to define a function or view that performs fairly intensive > > calculations and then index or cache these results? > > > > The data I have will be accessed more than modified, but still will be > > modified semi regularly. > > > > Would someone please enlighten me on my options for improving performance > is > > this situation? > > You could create a new table to store the results in and refresh it's > contents every time the original data changes and you can index > whatever you want, as long as you take into account that frequent and > extensive changes to a table with a couple of indexes might slow > things down a bit, depending on the number of changed records, the > number of indices you define on the table and so on... > You can keep the data in sync using triggers or with a periodic update > task, depending on what kind of precision you need. Perhaps an implemenation of a materialized view is more what you would like? http://archives.postgresql.org/pgsql-performance/2004-02/msg00279.php http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html Regards, Richard Broersma jr. -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.8/380 - Release Date: 6/30/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.8/380 - Release Date: 6/30/2006 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Is there any way to index or cache a view, or function results?
> I was hoping for something a bit more automatic with less maintenance from > me. Thank you for your reply. > On 7/1/06, Jason Long <[EMAIL PROTECTED]> wrote: > > > > Is it possible to define a function or view that performs fairly intensive > > calculations and then index or cache these results? > > > > The data I have will be accessed more than modified, but still will be > > modified semi regularly. > > > > Would someone please enlighten me on my options for improving performance > is > > this situation? > > You could create a new table to store the results in and refresh it's > contents every time the original data changes and you can index > whatever you want, as long as you take into account that frequent and > extensive changes to a table with a couple of indexes might slow > things down a bit, depending on the number of changed records, the > number of indices you define on the table and so on... > You can keep the data in sync using triggers or with a periodic update > task, depending on what kind of precision you need. Perhaps an implemenation of a materialized view is more what you would like? http://archives.postgresql.org/pgsql-performance/2004-02/msg00279.php http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html Regards, Richard Broersma jr. ---(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
Re: [GENERAL] Postgresql does not start on reboot
2006/7/1, Tom Lane <[EMAIL PROTECTED]>: "Clodoaldo Pinto" <[EMAIL PROTECTED]> writes: > There is a simlink in /var/lib/pgsql/data pointing to /disk2/pg_xlog > which is in sbd1 and is owned by postgres. You need to modify the selinux policy to let the postmaster access /disk2/pg_xlog ... by default, it's constrained to only be able to touch stuff under /var/lib/pgsql. I followed this: http://fedora.redhat.com/docs/selinux-faq-fc5/#id2961385 I will reboot in a few days and then I will know if it is fixed. Clodoaldo ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] Is there any way to index or cache a view, or function results?
I was hoping for something a bit more automatic with less maintenance from me. Thank you for your reply. Thank you for your time, Jason Long CEO and Chief Software Engineer BS Physics, MS Chemical Engineering http://www.supernovasoftware.com HJBUG Founder and President http://www.hjbug.com -Original Message- From: Tomi NA [mailto:[EMAIL PROTECTED] Sent: Saturday, July 01, 2006 4:17 PM To: [EMAIL PROTECTED] Subject: Re: [GENERAL] Is there any way to index or cache a view, or function results? On 7/1/06, Jason Long <[EMAIL PROTECTED]> wrote: > > Is it possible to define a function or view that performs fairly intensive > calculations and then index or cache these results? > > The data I have will be accessed more than modified, but still will be > modified semi regularly. > > Would someone please enlighten me on my options for improving performance is > this situation? You could create a new table to store the results in and refresh it's contents every time the original data changes and you can index whatever you want, as long as you take into account that frequent and extensive changes to a table with a couple of indexes might slow things down a bit, depending on the number of changed records, the number of indices you define on the table and so on... You can keep the data in sync using triggers or with a periodic update task, depending on what kind of precision you need. Cheers, t.n.a. -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.8/380 - Release Date: 6/30/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.8/380 - Release Date: 6/30/2006 ---(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
[GENERAL] Is there any way to index or cache a view, or function results?
Is it possible to define a function or view that performs fairly intensive calculations and then index or cache these results? The data I have will be accessed more than modified, but still will be modified semi regularly. Would someone please enlighten me on my options for improving performance is this situation? Thank you for your time, Jason Long CEO and Chief Software Engineer BS Physics, MS Chemical Engineering http://www.supernovasoftware.com HJBUG Founder and President http://www.hjbug.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.8/380 - Release Date: 6/30/2006
Re: [GENERAL] Postgresql does not start on reboot
"Clodoaldo Pinto" <[EMAIL PROTECTED]> writes: > There is a simlink in /var/lib/pgsql/data pointing to /disk2/pg_xlog > which is in sbd1 and is owned by postgres. You need to modify the selinux policy to let the postmaster access /disk2/pg_xlog ... by default, it's constrained to only be able to touch stuff under /var/lib/pgsql. regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] Postgresql does not start on reboot
Postgresql does not start on reboot but starts normally with "pg_ctl
start". Running FC5 with selinux enabled.
# chkconfig --list postgresql
postgresql 0:off 1:off 2:on3:on4:on5:on6:off
/etc/selinux/config:
SELINUX=enforcing
SELINUXTYPE=targeted
SETLOCALDEFS=0
In /var/log/messages there is this message:
kernel: audit(1151719618.110:4): avc: denied { search } for
pid=1849 comm="postmaster" name="/" dev=sdb1 ino=2
scontext=system_u:system_r:postgresql_t:s0
tcontext=system_u:object_r:file_t:s0 tclass=dir
There is a simlink in /var/lib/pgsql/data pointing to /disk2/pg_xlog
which is in sbd1 and is owned by postgres.
If is this a selinux problem, how can I configure it to let postgres
use the pg_xlog dir in /disk2 on startup?
Regards, Clodoaldo Pinto
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Re: [GENERAL] SELECT statement in stored procedure
On Saturday 01 July 2006 09:08, "Alain Roger" <[EMAIL PROTECTED]> wrote: > it works but i get all fields from my accounts table. > > So how can i get only login and status ? > Define a composite type that includes only those fields and return SETOF that_new_type instead of SETOF accounts. Or select login,status from function_name() instead of select *. -- When we vote for taxes, we are voting to steal from our neighbors ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Dynamic technical graphics generation inside plperl query?
On Sat, Jul 01, 2006 at 12:49:45PM +0200, Philippe Lang wrote: > Hi, > > Is there a way to use a graphics drawing library (like GD for > example) inside a plperl function, and "stream" the result image > (bytea column?) without storing anything to the disk or database? > Has anyone done that before? Philippe, To include an external library, you'll need to use PL/PerlU, which means you'll be creating the fucntion as the database superuser, although other users can then invoke the function. Bytea doesn't have file semantics like seek(), but it can be the output of a function, so you should be good to go. I don't know whether the more file-like lo interface can be used this way, but it's seldom worth the trouble anyhow. Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(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
[GENERAL] SELECT statement in stored procedure
Hi, I have the following stored procedure : CREATE OR REPLACE FUNCTION immense_sp001(IN username VARCHAR, IN strhash VARCHAR) RETURNS SETOF accounts LANGUAGE plpgsql AS ' DECLARE Profile_Detected INTEGER :=0; act accounts%ROWTYPE; rec RECORD; BEGIN /* detect if the user logged in exists in database*/ SELECT count(*) INTO Profile_Detected FROM accounts WHERE login=username AND pwd=strhash; if (Profile_Detected = 1) then SELECT INTO act * FROM accounts; FOR rec IN select login,status from accounts LOOP RETURN NEXT rec; END LOOP; end if; return; END; '; so it should return only 2 fields from my account table (login and status). however it does not work. if i replace the line "FOR rec IN select login,status from accounts LOOP" by FOR rec IN select * from accounts LOOP it works but i get all fields from my accounts table. So how can i get only login and status ? thanks a lot, Alain ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] db question - dynamic fields in db
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 a wrote: > hi > i want to know > how to add a list of items to a database > it is basically text, but different fields > but the problem is i dont know how many fields are there before hand > > so i m not sure how to store them in the db > sometime i need to store 10 elements and some other times 5 > thanks a lot MUMPS has repeating fields, I think. :) Pick definitely does... Seriously, though, what you need to do is to put that section of the database into "1st Normal Form". For example, a "sales record" has an sales id number, customer name, transaction date/time, store number, cash_credit flag, credit card number, reversal/adjustment flag, and the list of items purchased. So, this is how the tables would look: T_SALES_HEADER - -- SALES_IDINTEGER PRIMARY KEY, CUST_ID INTEGER FOREIGN KEY (T_CUSTOMER_NAME.CUST_ID), TRAN_DATE DATE, TRAN_TIME TIME, STORE_IDSMALLINT, EMPLOYEE_ID INTEGER, CASH_CREDIT_FL CHAR(1), IS_REVERSAL_FL CHAR(1), IS_REVERSED_FL CHAR(1), XREF_SALES_ID INTEGER T_SALES_CC_DETAIL - - SALES_IDINTEGER PRIMARY KEY FOREIGN KEY (T_SALES_HEADER.SALES_ID), CC_NUMBER CHAR(16), EXPIRE_DATE CHAR(6) T_SALES_DETAIL - -- SALES_IDINTEGER FOREIGN KEY (T_SALES_HEADER.SALES_ID), TRAN_SRLNO SMALLINT, INVENTORY_IDINTEGER FOREIGN KEY (T_INVENTORY.INVENTORY_ID), QUANTITYSMALLINT, SALE_AMOUNT NUMERIC(10,2) PRIMARY KEY (SALES_ID, TRAN_SRLNO) - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEppjZS9HxQb37XmcRApNQAJ9L3GZCxVj1pUuCioId5QkpOp7FlACeJQkY JDIoYyAdLvanH9g7JMyAZJM= =jufR -END PGP SIGNATURE- ---(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
Re: [GENERAL] pgsql vs mysql
"Merlin Moncure" 寫道： > On 30 Jun 2006 08:58:27 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I am new to pgsqlI really appreciate the licensing terms of > > pgsql...mysql licensing is a little bit risky to use... > > > > Q. when using pgsql as a very heavy and mission critical applications, > > what are the advantages of using pgsql instead of mysql? > > ok, this is pretty much a faq and you can get lots of information > about this from the archives and from the internet itself. However, > there is tons of disinformation about there so be careful Here are > the major points you need to consider, based on my experience: > > * mysql performance advantage is greatly overstated, although > postgresql requires you to use certain conventions (example: prepared > statements) to get comparable performance > * both databases (IMO) are very stable. in 6 years of workikng with > both databases, I've never had either 'just crash' without external > mitigating circumstances, a testimonial to both projects > * mysql tends to encourage development in application code, while pg > tends to encourage development in the database iteself. For various > reasons, I greatly prefer the latter. > * pg, in my opinion, has a better unicode handling, although there is > a small learning curve to do it the best way > * pg mvcc transactional engine is better than innodb (IMO), and faster > when used properly > * pg pl/pgsql is much better than (mysql 5.0) stored procedures. you > also have a lot of other languages to use if you want > * pg is generally much more flexible and extensible > * mysql has decent out of the box replication that is easy to set up > (one day I hope pg get hot PITR which is analagous feature) > * pg has IMO much better shell and standardized syntax > * pg query planer rivals top commercial databse engines > * mysql has a few features here and there which are nice...just to > name a few, flush tables with lock, multiple insert, etc > > there are lots of other things. if you want to use a mission critcal > database engine for new project, I believe there to be only one > choice, but you have to take a lot of things into consideration; > support, development style, and a host of other factors. If you > follow the pg lists I think you will find the support here to be > unbelievably good. > > Merlin > > ---(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 thanks. very useful! ---(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
[GENERAL] db question - dynamic fields in db
hi i want to know how to add a list of items to a database it is basically text, but different fields but the problem is i dont know how many fields are there before hand so i m not sure how to store them in the db sometime i need to store 10 elements and some other times 5 thanks a lot a ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] different sort order in windows and linux version
On Fri, Jun 30, 2006 at 07:29:12PM +0200, Tomi NA wrote: > If I sound harsh, please excuse me, but I feel like I'm the only one > who thinks these encoding problems (collation, upper/lowercase, > multiple languages in a single database) are serious...nobody seems to > share the sentiment. Ah well... I agree with you, however the resistance (AFAICS) comes mostly from the fact that we would be depending on an external library to do it. I don't think postgres should try doing it itself, given that the unicode character databases are quite large by themselves. Alternativly, the postgres group could produce a customised version of ICU that's smaller (the website has details about how). But any case, this problem will need to be addressed at some point. Have a nice day, -- Martijn van Oosterhout http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate. signature.asc Description: Digital signature
Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL
On Fri, Jun 30, 2006 at 11:26:06PM -0400, Tom Lane wrote: > Something that would actually hold some intellectual interest is to > improve the testing infrastructure. The current setup is pretty limited > as to its ability to deal with varying outputs, and even more limited > in its ability to test concurrent behavior. Again, see the archives. I must admit I was kind of surprised this didn't generate much feedback: http://archives.postgresql.org/pgsql-hackers/2005-08/msg01073.php It's a simple tester that drives multiple postgres backends simultaneously and can test whether various concurrently running transaction correctly block/abort in various situations. I also used it to test whether all the different LOCK types work as documented in the documentation (they do, the program checked all combinations of two locks). It would in theory be possible to generate scripts to test thing like simultaneously firing multiple CREATE INDEX commands in seperate transactions and see how they interact. Have a nice day, -- Martijn van Oosterhout http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate. signature.asc Description: Digital signature
[GENERAL] Dynamic technical graphics generation inside plperl query?
Hi, Is there a way to use a graphics drawing library (like GD for example) inside a plperl function, and "stream" the result image (bytea column?) without storing anything to the disk or database? Has anyone done that before? Thanks, --- Philippe Lang Attik System smime.p7s Description: S/MIME cryptographic signature
