ThinkingMonkey

215 reputation

bio	website
	location
	age
visits	member for	1 year, 6 months
	seen	Apr 2 at 19:45
stats	profile views	26

Free-Thinker, Individualist, INTP

	215 reputation	bio	website		visits	member for	1 year, 6 months
19 badges		location			seen	Apr 2 at 19:45

summary answers questions tags badges favorites bounties reputation activity

75 Actions

suggestions reviews revisions comments badges posts accepts all

Apr 9	awarded	Popular Question
Apr 7	awarded	Popular Question
Nov 28	awarded	Yearling
Sep 21	awarded	Custodian
Sep 3	comment	PostgreSQL 9.1 vs MySQL 5.6 with InnoDB ? Which is better for scaling? Thanks for the insight. +1.
Aug 27	comment	WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT? BTW, used `ALTER ROLE user SET search_path TO "$user",public;` to set the search path. Although, $user is useless as I do not have any schema named after the current users.
Aug 27	accepted	WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
Aug 27	comment	WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT? @JackDouglas It was a search path problem for the user I was trying to login as. I am guessing I had created the user when I had done a session-wise `set search_path` to some other schema and instead of the default '"$user",public' it was set to the other schema. The user did not have any access to `public schema` at all. Thanks to `Daniel Vérité` for pointing me in the right direction.
Aug 27	comment	WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT? It was a search path problem for the user I was trying to login as. I am guessing I had created the user when I had done a session-wise `set search_path` to some other schema and instead of the default '"$user",public' it was set to the other schema. The user did not have any access to public schema at all. Thanks for pointing me in the right direction.
Aug 27	comment	WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT? @JackDouglas Yes, I have.. it works as excepted. CITEXT does gets recognized as a valid datatype. And the result is a single row.
Aug 27	comment	WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT? @JackDouglas both the installations have the same user and same grant permissions
Aug 27	asked	WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
Aug 15	revised	Starting PostgreSQL server after a HDD crash results in FAILED STATE added 60 characters in body
Aug 14	comment	Starting PostgreSQL server after a HDD crash results in FAILED STATE @CraigRinger no luck. Let me give it a proper try again.
Aug 14	comment	Starting PostgreSQL server after a HDD crash results in FAILED STATE @CraigRinger what is the above supposed to do?
Aug 14	comment	Starting PostgreSQL server after a HDD crash results in FAILED STATE @CraigRinger trying it now..
Aug 14	comment	Starting PostgreSQL server after a HDD crash results in FAILED STATE @CraigRinger Will give it a try(the dummy data). Thanks for all the help :).
Aug 14	accepted	Starting PostgreSQL server after a HDD crash results in FAILED STATE
Aug 14	comment	Starting PostgreSQL server after a HDD crash results in FAILED STATE @CraigRinger Yes I do have a back-up. I actually am enjoying this ride.
Aug 14	comment	Starting PostgreSQL server after a HDD crash results in FAILED STATE Have updated the question with details after make a complete file system level copy of /var/lib/pgsql then running `pg_resetxlog` . Server still does not start.