Barrett Griffith forgotpw1

Any situation which causes a Context object to go out of scope (which can happen if additional context objects are created in the course of the processing) can leave a hanging transaction.

	For your reference, you can use the following test credit card numbers when testing your connection. The expiration date must be set to the present date or later:
	- American Express Test Card: 370000000000002
	- Discover Test Card: 6011000000000012
	- Visa Test Card: 4007000000027
	- Second Visa Test Card: 4012888818888
	- MasterCard: 5555555555554444
	- JCB: 3088000000000017
	- Diners Club/ Carte Blanche: 38000000000006

	SELECT pg_terminate_backend(pid)
	FROM pg_stat_activity
	WHERE datname = 'DB'
	AND pid <> pg_backend_pid()
	AND state = 'idle in transaction (aborted)'
	AND state_change < current_timestamp - INTERVAL '5' MINUTE

	SELECT relation, transaction, pid, mode, granted, relname
	FROM pg_locks
	INNER JOIN pg_stat_user_tables
	ON pg_locks.relation = pg_stat_user_tables.relid
	WHERE pg_locks.pid='pid';

	(sudo -u postgres pg_ctl stop -D /usr/local/pgsql/data -m i -t 5 \|\| true) && sudo stop postgresql

	# start again with

	sudo start postgresql