PostgreSQL
10
PostgreSQL Database
Curated by footcow
Follow
Your new post is loading...
Scooped by footcow
Scoop.it!

Official sqlmap video demonstration 8

Official sqlmap video demonstration 8 | PostgreSQL | Scoop.it
Demonstration of sqlmap command execution features: sqlmap is launched against a PHP test page hosted on a Debian GNU/Linux 5.0 server with back-end database management system being PostgreSQL 8.4. The tool is instructed to identify possible SQL injections and exploit them by executing a command on the database server operating system. sqlmap first uploads a dynamic-linked library (DLL) used to create two user-defined functions (sys_exec() and sys_eval()) in the database. Then it asks the user if he wants to retrieve the command standard output. If the answer is positive, sqlmap executes the command once and stores its standard output in a support table. Either boolean-based blind SQL injection or UNION query SQL injection technique is used to dump the entry of this table and delete it afterwards. This technique is also implemented for MySQL. On Microsoft SQL Server, xp_cmdshell extended stored procedure is used to execute commands on the underlying operating system. sqlmap, sqlmap.sourceforge.net, is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of back-end database servers. It comes with a broad range of features lasting from database fingerprinting, over data fetching from the database, to accessing the underlying file system and executing commands on the operating system via out-of-band connections.
Philippe Gassmann's comment, December 4, 2010 8:35 PM
impressive!
Scooped by footcow
Scoop.it!

Download psycopg2 2.3.0 for Linux - Python-PostgreSQL Database Adapter - Softpedia

Download psycopg2 2.3.0 for Linux - Python-PostgreSQL Database Adapter - Softpedia | PostgreSQL | Scoop.it
psycopg2 Python-PostgreSQL Database Adapter (psycopg2 2.3.0: Python-PostgreSQL Database Adapter http://twurl.nl/a2g0ix)
No comment yet.
Scooped by footcow
Scoop.it!

new version of pst collection is relased

new version of pst collection is relased | PostgreSQL | Scoop.it
HelloI released a updated version of pst collection. What is a pst collection? It is a collection of usable functions for ...
No comment yet.
Scooped by footcow
Scoop.it!

Feature request: INSERT .... ON DUPLICATE UPDATE ....

Dear all, In our company, we use both PostgreSQL and MySQL, our developers include me think that the "INSERT ... ON DUPLICATE UPDATE " clause is a much more user friendly funct (http://www.listware.net/201011/postgresql-hackers/100978-feature-request-insert-on-duplicate-update-.html Feature request: INSE)
No comment yet.
Scooped by footcow
Scoop.it!

PostgreSQL Replication with Slony-I

PostgreSQL Replication with Slony-I | PostgreSQL | Scoop.it
A detailed look at how to implement asynchronous, master-slave replication in PostgreSQL using Slony-I, along with analysis of how this differs from using PGCluster for replication.
No comment yet.
Scooped by footcow
Scoop.it!

pgpool-II 3.0 officially released

pgpool-II 3.0 officially released | PostgreSQL | Scoop.it
After nearly one month testing, we finally sent out pgpool-II 3.0 to the door on September 10, 2010. On that day SRA OSS, Inc. ...
No comment yet.
Scooped by footcow
Scoop.it!

use a plpgsql well

use a plpgsql well | PostgreSQL | Scoop.it
HelloI found a following code on net. It's good example of bad code (written by PHP coder):01.CREATE OR REPLACE FUNCTION ...
No comment yet.
Scooped by footcow
Scoop.it!

Simple counter for batch operations

Simple counter for batch operations | PostgreSQL | Scoop.it
HelloI am working with large transformations now. It is some like:CREATE TABLE source_table(..);CREATE TABLE ...
No comment yet.
Scooped by footcow
Scoop.it!

sysbench, PostgreSQL 9.0 and OLTP complex read-write test

sysbench, PostgreSQL 9.0 and OLTP complex read-write test | PostgreSQL | Scoop.it
Continuing with my sysbench saga with PostgreSQL 9.0, I was generally not encountering any errors except recently. I found two ...
No comment yet.
Scooped by footcow
Scoop.it!

PostgreSQL 9.0 Simple Select Scaling using sysbench

PostgreSQL 9.0 Simple Select Scaling using sysbench | PostgreSQL | Scoop.it
While I still haven't found a working way to test sysbench read-write test, I decided to continue on sysbench testing with ...
No comment yet.
Scooped by footcow
Scoop.it!

Conference Schedule - PGDay.EU 2010 - PostgreSQL Europe

Conference Schedule - PGDay.EU 2010 - PostgreSQL Europe | PostgreSQL | Scoop.it
(The Official Schedule https://www.postgresql.eu/events/schedule/pgday2010/ #PgDay.EU2010 #PostgreSQL - The Official... http://is.gd/hIKkS)
No comment yet.
Scooped by footcow
Scoop.it!

Compiler pgpool II 3.0.1 sous Debian | Pad's Notes

Compiler pgpool II 3.0.1 sous Debian | Pad's Notes | PostgreSQL | Scoop.it
- Installer les dependances necessaire a la compilation : - Telecharger les sources sur http://pgpool.projects.postgresql.org/ puis les decompresser - (Pad's Blog: Compiler pgpool II 3.0.1 sous Debian http://bit.ly/eQztca pgpool)
No comment yet.
Scooped by footcow
Scoop.it!

Robert Haas: Profiling PostgreSQL

Robert Haas: Profiling PostgreSQL | PostgreSQL | Scoop.it
I did a little bit of work Tuesday night and Wednesday profiling PostgreSQL.  I ran two different tests.  The first ...
No comment yet.
Scooped by footcow
Scoop.it!

Easy way to prevent SQL Injections on PostgreSQL in PHP | web ninja emi?

Easy way to prevent SQL Injections on PostgreSQL in PHP | web ninja emi? | PostgreSQL | Scoop.it
(New post: Easy way to prevent SQL Injections on PostgreSQL in PHP http://bit.ly/g0SSoc)
No comment yet.
Scooped by footcow
Scoop.it!

Run an efficient PostgreSQL database using Packt's new book

Run an efficient PostgreSQL database using Packt's new book | PostgreSQL | Scoop.it
Run an efficient PostgreSQL database using Packt's new book. PostgreSQL 9.0 Administration Cookbook is a new book from Packt which offers the information the readers need to manage their live production databases on PostgreSQL. - PR11116012 (Run an efficient PostgreSQL database using Packt's new book: PRLog (Press Release) – Dec 01, 2010 – PostgreSQL 9... http://bit.ly/hGkPvt)
No comment yet.
Scooped by footcow
Scoop.it!

Quick Intro to R and PL/R - Part 1

Quick Intro to R and PL/R - Part 1 | PostgreSQL | Scoop.it
In this article we'll provide a summary of what PL/R is and how to get running with it. Since we don't like repeating ...
No comment yet.
Scooped by footcow
Scoop.it!

Move a PostgreSQL database to a different tablespace | Routing Life

Move a PostgreSQL database to a different tablespace | Routing Life | PostgreSQL | Scoop.it
Life at a belgian navigation startup (Move a PostgreSQL database to a different tablespace | Routing Life: SELECT * FROM "pg_tables"; http://bit.ly/hOHqXw)
No comment yet.
Scooped by footcow
Scoop.it!

Using pgpool-II for persistent PostgreSQL connections

Using pgpool-II for persistent PostgreSQL connections | PostgreSQL | Scoop.it
If you have high-traffic php applications connecting to a PostgreSQL backend, and you're not using pgpool for persistent connections, you're missing out on a great way to slash the load on your db server.
No comment yet.
Scooped by footcow
Scoop.it!

PostgreSQL 9.1 - iteration over array

PostgreSQL 9.1 - iteration over array | PostgreSQL | Scoop.it
I finished patch that enable iteration over array. I hope so new syntax can helps to better readability. There are a few ...
No comment yet.
Scooped by footcow
Scoop.it!

diff string for PostgreSQL

diff string for PostgreSQL | PostgreSQL | Scoop.it
Hello,I am working on migration a large dataset from archive to a new format. This work is joined with searching a small ...
No comment yet.
Scooped by footcow
Scoop.it!

Tutorial to pgpool-II plus Streaming replication

Tutorial to pgpool-II plus Streaming replication | PostgreSQL | Scoop.it
I have written a tutorial to pgpool-II using PostgreSQL 9.0's streaming replication. The tutorial is designed to use minimum ...
No comment yet.
Scooped by footcow
Scoop.it!

Heroku PostgreSQL Database Add-on Gets Update

Heroku PostgreSQL Database Add-on Gets Update | PostgreSQL | Scoop.it
Heroku releasing an update to our dedicated database service. Heroku PostgreSQL provides an improved upgrade path for our users ...
No comment yet.
Scooped by footcow
Scoop.it!

Dynamic Triggers in PLpgSQL

Dynamic Triggers in PLpgSQL | PostgreSQL | Scoop.it
You certainly know that implementing dynamic triggers in PLpgSQL is
impossible. But I had a very bad night, being up from as ...
No comment yet.
Scooped by footcow
Scoop.it!

Fixing Foreign Key Deadlocks in PostgreSQL

PGX had a client come to us recently with a rather nasty deadlock issue. It took far longer than we would have liked to figure ...
No comment yet.
Scooped by footcow
Scoop.it!

PGDay.EU - where's your country? - Magnus Hagander's PostgreSQL blog

PGDay.EU - where's your country?  - Magnus Hagander's PostgreSQL blog | PostgreSQL | Scoop.it
(RT @gnubyexample: Now I know there are more UK users of Postgresql, who might be interested in making it to Pgday.eu http://bit.ly/dPcbTK #organise #travel)
No comment yet.