HNHacker News
TopNewBestAskShowJobs

sickpig

384 karma · joined May 15, 2012

[ my public key: https://keybase.io/sickpig; my proof: https://keybase.io/sickpig/sigs/NhGo_0zgq9NoE97TTFVxuXv_5n2SJRH58-0SpVIQAp8 ]
submissionscomments
sickpig··on China Bans Financial Companies From Bitcoin Transactions
no exchanges? really?
sickpig··on Bitcointalk Forum Hacked
Bitcointalk.org users data for sale?

see http://pastebin.com/6S2H21eF

sickpig··on The People of Postgres: Tom Lane
to add a small thing to what Selena already said, Salesforce is sponsoring the "Unconference" day at PgCon 2013 (held in Ottawa this week). It could be nothing but it seems to me a good thing.

Despite of that, I think that if Salesforce will let Tom to focus on postgresql development as RedHat did in the past we(1) are ok.

(1) = postgresql users

sickpig··on The People of Postgres: Tom Lane
I clearly remember that somewhere in 2001 I wrote to postgres (-bugs maybe) mailing list about a problem that we had with one of our server (it's a pity I didn't find the thread on the archives). pg_xlog run out of space due to some problem with WAL files recycling mechanism. I got a reply from Tom almost immediately asking for more details. After a few hours he saved my day sending me a freshly baked patch that solved the problem. amazing. I have a deep respect for him.
sickpig··on Send money with Gmail
I thought the same thing till I saw this

http://hackaday.com/2012/11/16/google-books-team-open-source...

sickpig··on Dribbble offline due to Postgres problem
Did they try to post about their problem on postgresql mailing list (both pgsql bugs and general apply here)?

Postgres community is quite responsive and usually give very effective advice, as long as you use the proper channel to communicate.

sickpig··on PostgreSQL 9.3 Beta 1 Released
Postgresql documentation is terrific, really [1]. Then you can also use pgsql wiki [2]. Other useful resources are the searchable mailing lists archive [3]. Have a look also to pgcon.org web site, it's fully packed of presentation material (mainly pdf slides) gathered since 2007, just to give you an example look at Tom Lane's "http://www.pgcon.org/2011/schedule/events/350.en.html [4]

Speaking of books a few of the best I'm aware of are:

- PostgreSQL 9 Admin Cookbook (Simon Riggs, Hannu Krosing)

- PostgreSQL 9.0 High Performance (Gregory Smith)

- Instant PostgreSQL Backup and Restore How-to (Shaun M. Thomas)

all them from Packt Publishing

[1] http://www.postgresql.org/docs/devel/static/

[2] http://wiki.postgresql.org/wiki/Main_Page

[3] http://www.postgresql.org/list/

[4] http://www.pgcon.org/2011/schedule/events/350.en.html

sickpig··on PostgreSQL 9.3 Beta 1 Released
for a more in depth list of changes / new features look at release note[1] and the wiki 9.3Beta1 page[2]

[1] http://www.postgresql.org/docs/devel/static/release-9-3.html

[2] http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9...

sickpig··on PostgreSQL 9.2.4, 9.1.9, 9.0.13 and 8.4.17 released
Yep this is what I meant. I could have chosen my words in a better way though, since we were talking about a git commit. Having said that quoting commit message 2nd last paragraph:

The Postgres project thanks Mitsumasa Kondo for discovering this bug, Kyotaro Horiguchi for drafting the fix, and Noah Misch for recognizing the full extent of the danger.

We can't exclude without further info that Tom contributed to the fix, just saying.

Knowing him after a few years spent following postgres dev process I bet on co-authoring at least :)

sickpig··on PostgreSQL 9.2.4, 9.1.9, 9.0.13 and 8.4.17 released
And the author is a fantastic coder/developer, really!

https://en.wikipedia.org/wiki/Tom_Lane_%28computer_scientist...

sickpig··on Terminology – a new terminal emulator
you use the /usr/bin/script program to record a transcript of a session. no term emulators that i know of provide this kind of feature natively though.
sickpig··on How I work with Postgres – psql, My PostgreSQL Admin
PostgreSQL 9.0 High Performance, Gregory Smith

Postgresql 9 Administration Cookbook, Simon Riggs, Hannu Krosing

sickpig··on Plivo (YC S12) Launches the first SDK that connects WebRTC And SIP
Speaking of webrtc and sip just try sipml5.org I've just tested it with asterisk 11.2.0 and after a bit of fighting I was able to make it works (I'm not affiliated).
sickpig··on Postgres 9.2 – The Database You Helped Build
Not from heroku guys but definitely a worth reading http://thebuild.com/blog/2012/05/18/running-postgresql-on-aw...
sickpig··on Regexp-based RFC822 email address validation
@work we have done a lot of this kind of validations using a custom Tcl script, and luckily we have avoided to be blacklisted till now. Maybe it's due to the fact that validation requests come from an IP address marked as MX for the domain of the sender email address.

Anyway not all SMTP servers are RFC compliant, they respond with a 2XX code to a "RCPT TO" even if user/mailbox doesn't exists. The same thing applies also if the SMTP server is acting as a relay and has no immediate access to the delivering system.

sickpig··on Why Postgres
as already mentioned there's no in core multi master replication, but other then the already listed solutions, you can have look at :

http://postgres-xc.sourceforge.net/

the project is sponsored by Enterprisedb and NTT

a quote from the home page:

"Postgres-XC is an open source project to provide a write-scalable, synchronous multi-master, transparent PostgreSQL cluster solution. It is a collection if tightly coupled database components which can be installed in more than one hardware or virtual machines."

[edit: sorry for the noise I did't notice that jeff davis already comment about postgres-xc]

sickpig··on Google Talk is down
Up and running now in Italy
sickpig··on PostgreSQL 9.2 beta adds JSON
just validation, json core type it's intentionally very minimal (see postgres hackers mailing list archives for more details)

anyway as a possible workaround just see andrew dustan's post:

http://people.planetpostgresql.org/andrew/index.php?/archive...

← PreviousPage 2 of 2