...p when your database went down.
thanks for reading this long article please correct me if i write something wrong hope help.
postgresql official pointintime recovery reference
httpwww .postgresq l.orgdocs 8.0inter activebac kuponline .html
how to export table data to file csv postgresql
how to kill terminate postgresql hang query
to date function between postgresql 8.2 an... [Show More]
the last post setup a basic linux environment with secure access for administration. this post
will now turn that basic install into a web and database server. ill be using apache 2 and
postgresql
to achieve this. both are very simple to setup especially on ubuntu.
apache 2
sudo aptget install apache2 will install apache configure it all and start it r...... [Show More]
sqlite is an extremely useful little database. it has a nifty bunch of features and is super simple to set up. using sqlite reduces the cost of developing and maintaining a powerful sql database even more than traditional free rdbms like postgresql and mysql . your database is simply an ondisk file no need to configure user accounts connection strings or any of that stuff.
wh...... [Show More]
reepli.com is the atlanta startup weekend 2 project created by erik peterson mark luffel hamed hashemi amro mousa joe uhl and me. aim really proud of how the team worked together and the amount of stuff that we were able to get done in a very short period of time. awe closed out 45 issue items over the course of 48 hours. athats a pretty good clip.
since the sites s...... [Show More]
the first of two invited posts at gigaom aare up. athese are not researchy theyre intended to be informative to a broad audience. athey describe the state of affairs in data parallelism and some of the reasons why this is an increasingly hot topic.
this started out as an exercise for greenplum a company i advise that sells a massively parallel dbms based on postgresql . ai821...... [Show More]
we got a setup in which postgresql is a fairly important beastie. trouble is for some reason the postgresql server sometimes stops responding. the logging doesnt reveal all that much information without increasing its level which would impact performance which is not what we want for a production database. so we need some way to inspect the queries that are sent to the server ...... [Show More]
postgresql 8.3.5 Post Source: www.comvan.com Posted: Nov 01 2008 03:32:58
postgresql is a powerful open source relational database system. it has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability data integrity and correctness.ait runs on all major operating systems including linux unix aix bsd hpux sgi irix mac os x solaris sunos tru64 beos and windows. it is fully acid c...... [Show More]
full disclosure im no postgres expert. in fact im pretty much a total noob myself.
which ironically makes me uniquely qualified to write the postgres tutorial that follows. an old hand is exactly the guy who you dont want to write a guide about common newbie problems because as the old writers saw goes you do your best writing when you write what you know.
an...... [Show More]
instalacian y analisis de errores de la instalacian del erp
la nueva versian 2.40 del erp openbravo salio el mes octubre 2008a openbravo es la 2.40 . openbravo es para las pequeaas y medianas empresas no mas de 50 trabajadores de cadigo abierto open source y sin coste de licencia basado en web y con los madulos maestros compras almacan produccian ventas...... [Show More]
when a librarian talks about a dat abase822 1 he or she usually means a website that will let you search for information not normally found in google.aa a techy would probably correct on this and say actually google is a database too.aaa and a real pedant would say something horrible like actually both of you are wrong.aa what you are talking about are interfa...... [Show More]
comentado el aspecto lagico del juego en artaculos anteriores de este post mortem toca revisar la parte tacnica de win or defeat . tecnologaas bases de datos fundamentos tacnicos la base siempre ha sido la misma pero segan fue evolucionando la lagica fue necesario optar por implementaciones mas potentes. asa
en la primera etapa del proyecto todo el cadigo fue des...... [Show More]
i recently spent some time debugging while i cant connect to a local postgresql database. i wanted the nice db database to be accessible to all local users not real names without any authentication. the trust authentication method was what i needed for this scenario i was sure of this much. so i set up an authentication record in the configuration file below the one...... [Show More]
working and waiting Post Source: www.oracle-internals.com Posted: Oct 21 2008 03:24:26
just to update everyone. first for those of you who keep bugging me i havent yet heard back from oracle regarding sibylnet . regardless im still hopeful that they will be ok with it and that i can pursue it openly. second ive been aber busy writing a few opensource utilities for work including a linux buffer cache profiler and primer a specialized copyonwrite fil...... [Show More]
nao se assuste ninguam esta pensando em fazer uma versao do postgresql em lisp
numa discussao recente na pghackers alguam sugeriu que o postgresql fosse reimplementado em c atualmente o cadigo esta em c. entre umas e outras ironias e mensagens de primeiro de abril tom lane apontou que o cadigo original do postgres tinha sido portado de outra linguagem ...... [Show More]
hi
due to a user request to use tsearch2 we upgraded postgresql from 8.1 to 8.3 without any other consideration it should have taken a few minutes but of course it would have been too easy so we fought against bugs and finally spent several hours on it.
there are many changes between these two versions please read the postgresql release notes
beside other things the charset used ...... [Show More]
sqlite3 is a very lightweight implementation of a sql database.a ive been using it in conjunction with python on a singlethreaded tool.a this morning i started refactoring my tool to have multiprocess support but i was interrupted by the following error
sqlite3.op erationale rror database is locked
after reading through the sqlite3 documentation i found that sqlite3 does databas...... [Show More]
visit original sd.rb episode 055 mysql postgres and rails
guyren howe has considerable experience with both mysql and postgresql . he discusses the myriad technical and other advantages to using postgresql instead of mysql for well pretty much anything.
bonus content download the slides from this talk.
read more about this video
want to control this...... [Show More]
Feeds and posts are not affliated with ://URLFAN. They are displayed here simply for informational purposes, if you would like to remove your feed please contact us.
Bloggers mention this site on average every 2 days.
E-mail me
Feed subscribe
Is this your website? Activate our 
