south create_table doesn't work
83 views
Skip to first unread message
Alessandro Candini
Feb 3, 2012, 4:33:13 AM2/3/12
to south...@googlegroups.com
I'm trying to use django-south-0.7.3 API's to create a table,
following
these:
http://south.aeracode.org/docs/databaseapi.html#accessing-the-api
http://dynamic-models.readthedocs.org/en/latest/topics/database-migration.html#topics-database-migration
these:
http://south.aeracode.org/docs/databaseapi.html#accessing-the-api
http://dynamic-models.readthedocs.org/en/latest/topics/database-migration.html#topics-database-migration
This is my code:
for item in modelFields:
modelAttrs[item.split(' = ')[0]] = item.split(' = ')[1]
modelAttrs['__module__'] = 'tss.models'
# Creation of new model class!
model_class = type(shpModel, (models.Model,), modelAttrs)
fields = [(f.name, f) for f in
model_class._meta.local_fields]
table_name = model_class._meta.db_table
dbs['lc'].create_table(table_name, fields)
dbs['lc'].execute_deferred_sql()
dbs['lc'].send_create_signal('tss', [shpModel])
The problem is that I do not get any error, but in the lc
database, no
table appears.
Where is the problem? What is missing?
Andrew Godwin
Feb 3, 2012, 5:45:22 AM2/3/12
to south...@googlegroups.com
On 03/02/12 09:33, Alessandro Candini wrote:
> I'm trying to use django-south-0.7.3 API's to create a table, following
> these:
> http://south.aeracode.org/docs/databaseapi.html#accessing-the-api
> <http://www.google.com/url?sa=D&q=http://south.aeracode.org/docs/databaseapi.html%23accessing-the-api&usg=AFQjCNGAEcDqje8WF7xjV42EHxK27renGw>> I'm trying to use django-south-0.7.3 API's to create a table, following
> these:
> http://south.aeracode.org/docs/databaseapi.html#accessing-the-api
> http://dynamic-models.readthedocs.org/en/latest/topics/database-migration.html#topics-database-migration
>
> This is my code:
> for item in modelFields:
> modelAttrs[item.split(' = ')[0]] = item.split(' = ')[1]
>
> modelAttrs['__module__'] = 'tss.models'
>
> # Creation of new model class!
> model_class = type(shpModel, (models.Model,), modelAttrs)
>
> fields = [(f.name, f) for f in model_class._meta.local_fields]
> table_name = model_class._meta.db_table
> dbs['lc'].create_table(table_name, fields)
> dbs['lc'].execute_deferred_sql()
>
> dbs['lc'].send_create_signal('tss', [shpModel])
>
>
> The problem is that I do not get any error, but in the lc database, no
> table appears.
> Where is the problem? What is missing?
Have you tried committing the transaction? db.commit_transaction() -
South is designed to operate inside them.
Andrew
Alessandro Candini
Feb 3, 2012, 6:03:32 AM2/3/12
to south...@googlegroups.com
I've added the following line as the last ofmy script:
dbs['lc'].commit_transaction()
and I get the following:
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "/home/candini/Repos/CanetaRepo/tmp/STO/TSS/tss/load.py", line
49, in loadShp
dbs['lc'].commit_transaction()
File "/usr/lib/pymodules/python2.7/south/db/generic.py", line 764, in
commit_transaction
transaction.commit()
File "/usr/lib/pymodules/python2.7/django/db/transaction.py", line
142, in commit
connection.commit()
File "/usr/lib/pymodules/python2.7/django/db/backends/__init__.py",
line 202, in commit
self.set_clean()
File "/usr/lib/pymodules/python2.7/django/db/backends/__init__.py",
line 147, in set_clean
raise TransactionManagementError("This code isn't under transaction
management")
TransactionManagementError: This code isn't under transaction management
What does this mean?
Alessandro Candini
Feb 3, 2012, 7:47:39 AM2/3/12
to South Users
Ok, a start_transaction() was missing.
I changed my script in the following way:
for item in modelFields:
modelAttrs[item.split(' = ')[0]] = item.split(' = ')[1]
modelAttrs['__module__'] = 'tss.models'
But nothing changed: no errors and no tables show up in the
database...
On Feb 3, 12:03 pm, Alessandro Candini <cand...@meeo.it> wrote:
> On 02/03/2012 11:45 AM, Andrew Godwin wrote:
>
>
>
>
>
>
>
>
>
> > On 03/02/12 09:33, Alessandro Candini wrote:
> >> I'm trying to use django-south-0.7.3 API's to create a table, following
> >> these:
> >>http://south.aeracode.org/docs/databaseapi.html#accessing-the-api
> >> <http://www.google.com/url?sa=D&q=http://south.aeracode.org/docs/datab...>
>
> >>http://dynamic-models.readthedocs.org/en/latest/topics/database-migra...
I changed my script in the following way:
for item in modelFields:
modelAttrs[item.split(' = ')[0]] = item.split(' = ')[1]
modelAttrs['__module__'] = 'tss.models'
model_class = type(shpModel, (models.Model,), modelAttrs)
fields = [(f.name, f) for f in model_class._meta.local_fields]
table_name = model_class._meta.db_table
dbs['lc'].start_transaction()
fields = [(f.name, f) for f in model_class._meta.local_fields]
table_name = model_class._meta.db_table
dbs['lc'].create_table(table_name, fields)
dbs['lc'].execute_deferred_sql()
dbs['lc'].send_create_signal('tss', [shpModel])
dbs['lc'].commit_transaction()
dbs['lc'].execute_deferred_sql()
dbs['lc'].send_create_signal('tss', [shpModel])
But nothing changed: no errors and no tables show up in the
database...
On Feb 3, 12:03 pm, Alessandro Candini <cand...@meeo.it> wrote:
> On 02/03/2012 11:45 AM, Andrew Godwin wrote:
>
>
>
>
>
>
>
>
>
> > On 03/02/12 09:33, Alessandro Candini wrote:
> >> I'm trying to use django-south-0.7.3 API's to create a table, following
> >> these:
> >>http://south.aeracode.org/docs/databaseapi.html#accessing-the-api
>
> >>http://dynamic-models.readthedocs.org/en/latest/topics/database-migra...
Andrew Godwin
Feb 3, 2012, 10:25:22 AM2/3/12
to south...@googlegroups.com
On 03/02/12 12:47, Alessandro Candini wrote:
> Ok, a start_transaction() was missing.
> I changed my script in the following way:
>
> for item in modelFields:
> modelAttrs[item.split(' = ')[0]] = item.split(' = ')[1]
>
> modelAttrs['__module__'] = 'tss.models'
>
> model_class = type(shpModel, (models.Model,), modelAttrs)
>
> fields = [(f.name, f) for f in model_class._meta.local_fields]
> table_name = model_class._meta.db_table
>
> dbs['lc'].start_transaction()
> dbs['lc'].create_table(table_name, fields)
> dbs['lc'].execute_deferred_sql()
>
> dbs['lc'].send_create_signal('tss', [shpModel])
> dbs['lc'].commit_transaction()
>
> But nothing changed: no errors and no tables show up in the
> database...
> Ok, a start_transaction() was missing.
> I changed my script in the following way:
>
> for item in modelFields:
> modelAttrs[item.split(' = ')[0]] = item.split(' = ')[1]
>
> modelAttrs['__module__'] = 'tss.models'
>
> model_class = type(shpModel, (models.Model,), modelAttrs)
>
> fields = [(f.name, f) for f in model_class._meta.local_fields]
> table_name = model_class._meta.db_table
>
> dbs['lc'].start_transaction()
> dbs['lc'].create_table(table_name, fields)
> dbs['lc'].execute_deferred_sql()
>
> dbs['lc'].send_create_signal('tss', [shpModel])
> dbs['lc'].commit_transaction()
>
> But nothing changed: no errors and no tables show up in the
> database...
Afraid I can't really help then. I'd check your query logs/django's
debug logs to see if any SQL is being sent at all.
Andrew
Alessandro Candini
Feb 6, 2012, 6:06:46 AM2/6/12
to South Users
I've checked with a minimal example to create a table into default
database using db method instead of dbs and it works.
dbs method, specifying the databease I want to work with, does not
work and seems a bug to me.
database using db method instead of dbs and it works.
dbs method, specifying the databease I want to work with, does not
work and seems a bug to me.
Andrew Godwin
Feb 6, 2012, 6:30:42 AM2/6/12
to south...@googlegroups.com
On 06/02/12 11:06, Alessandro Candini wrote:
> I've checked with a minimal example to create a table into default
> database using db method instead of dbs and it works.
>
> dbs method, specifying the databease I want to work with, does not
> work and seems a bug to me.
> I've checked with a minimal example to create a table into default
> database using db method instead of dbs and it works.
>
> dbs method, specifying the databease I want to work with, does not
> work and seems a bug to me.
Well, the db object is literally just an alias for dbs['default'], so
it's nothing intrinsic to multi-db - what are the differences between
the default database and the alternate one? Any different backends? options?
Andrew
Alessandro Candini
Feb 6, 2012, 7:11:47 AM2/6/12
to South Users
This is the default, where create_table works:
List of relations
Schema | Name | Type | Owner
--------+-----------------------------------+----------+----------
public | auth_group | table | tss
public | auth_group_id_seq | sequence | tss
public | auth_group_permissions | table | tss
public | auth_group_permissions_id_seq | sequence | tss
public | auth_message | table | tss
public | auth_message_id_seq | sequence | tss
public | auth_permission | table | tss
public | auth_permission_id_seq | sequence | tss
public | auth_user | table | tss
public | auth_user_groups | table | tss
public | auth_user_groups_id_seq | sequence | tss
public | auth_user_id_seq | sequence | tss
public | auth_user_user_permissions | table | tss
public | auth_user_user_permissions_id_seq | sequence | tss
public | django_admin_log | table | tss
public | django_admin_log_id_seq | sequence | tss
public | django_content_type | table | tss
public | django_content_type_id_seq | sequence | tss
public | django_session | table | tss
public | django_site | table | tss
public | django_site_id_seq | sequence | tss
public | geography_columns | view | postgres
public | geometry_columns | table | postgres
public | south_migrationhistory | table | tss
public | south_migrationhistory_id_seq | sequence | tss
public | spatial_ref_sys | table | postgres
(26 rows)
and this is the other one, where create_table does not work:
List of relations
Schema | Name | Type | Owner
--------+-------------------+-------+----------
public | geography_columns | view | postgres
public | geometry_columns | table | postgres
public | spatial_ref_sys | table | postgres
(3 rows)
Maybe the db needs to have south_migrationhistory table inside it?
List of relations
Schema | Name | Type | Owner
--------+-----------------------------------+----------+----------
public | auth_group | table | tss
public | auth_group_id_seq | sequence | tss
public | auth_group_permissions | table | tss
public | auth_group_permissions_id_seq | sequence | tss
public | auth_message | table | tss
public | auth_message_id_seq | sequence | tss
public | auth_permission | table | tss
public | auth_permission_id_seq | sequence | tss
public | auth_user | table | tss
public | auth_user_groups | table | tss
public | auth_user_groups_id_seq | sequence | tss
public | auth_user_id_seq | sequence | tss
public | auth_user_user_permissions | table | tss
public | auth_user_user_permissions_id_seq | sequence | tss
public | django_admin_log | table | tss
public | django_admin_log_id_seq | sequence | tss
public | django_content_type | table | tss
public | django_content_type_id_seq | sequence | tss
public | django_session | table | tss
public | django_site | table | tss
public | django_site_id_seq | sequence | tss
public | geography_columns | view | postgres
public | geometry_columns | table | postgres
public | south_migrationhistory | table | tss
public | south_migrationhistory_id_seq | sequence | tss
public | spatial_ref_sys | table | postgres
(26 rows)
and this is the other one, where create_table does not work:
List of relations
Schema | Name | Type | Owner
--------+-------------------+-------+----------
public | geography_columns | view | postgres
public | geometry_columns | table | postgres
public | spatial_ref_sys | table | postgres
(3 rows)
Maybe the db needs to have south_migrationhistory table inside it?
Andrew Godwin
Feb 6, 2012, 7:13:29 AM2/6/12
to south...@googlegroups.com
No, that's not required, that table is never even mentioned in the
database backend code in South. Could you turn on database query logging
and see what queries South is running on the other database, please?
Andrew
Alessandro Candini
Feb 6, 2012, 7:45:50 AM2/6/12
to South Users
I've used the maximum verbosity of postgresql logging, deleting lines
with "LOCATION" tag:
2012-02-06 13:39:01 CET DEBUG: 00000: my backend id is 2
2012-02-06 13:39:01 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:01 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:01 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:01 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:01 CET DEBUG: 00000: autovacuum: processing database
"tss_land_cover"
2012-02-06 13:39:01 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:01 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:01 CET DEBUG: 00000: pg_type: vac: 24 (threshold
113), anl: 24 (threshold 81)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_statistic: vac: 92
(threshold 120), anl: 444 (threshold 85)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_database: vac: 2 (threshold
50), anl: 7 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 88),
anl: 0 (threshold 69)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_attribute: vac: 285
(threshold 514), anl: 247 (threshold 282)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_proc: vac: 0 (threshold
654), anl: 0 (threshold 352)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_class: vac: 27 (threshold
101), anl: 27 (threshold 75)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_attrdef: vac: 24 (threshold
50), anl: 24 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_constraint: vac: 2
(threshold 51), anl: 2 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_index: vac: 7 (threshold
70), anl: 7 (threshold 60)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_operator: vac: 0 (threshold
191), anl: 0 (threshold 120)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
72), anl: 0 (threshold 61)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
119), anl: 0 (threshold 85)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
99), anl: 0 (threshold 74)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
74), anl: 0 (threshold 62)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_trigger: vac: 44 (threshold
51), anl: 40 (threshold 51)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_depend: vac: 1443 (threshold
1649), anl: 529 (threshold 849)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_shdepend: vac: 134
(threshold 748), anl: 166 (threshold 399)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: geometry_columns: vac: 2
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: spatial_ref_sys: vac: 0
(threshold 800), anl: 0 (threshold 425)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_toast_2619: vac: 12
(threshold 52), anl: 12 (threshold 51)
2012-02-06 13:39:01 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:01 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:01 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:01 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:01 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:01 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:01 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:01 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:01 CET DEBUG: 00000: server process (PID 12598)
exited with exit code 0
2012-02-06 13:39:06 CET DEBUG: 00000: my backend id is 2
2012-02-06 13:39:06 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:06 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:06 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:06 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:06 CET DEBUG: 00000: autovacuum: processing database
"template_postgis"
2012-02-06 13:39:06 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:06 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:06 CET DEBUG: 00000: pg_type: vac: 9 (threshold
107), anl: 37 (threshold 78)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_statistic: vac: 36
(threshold 119), anl: 41 (threshold 85)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_database: vac: 2 (threshold
50), anl: 7 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 88),
anl: 19 (threshold 69)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_attribute: vac: 0 (threshold
426), anl: 61 (threshold 238)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_proc: vac: 3 (threshold
654), anl: 0 (threshold 352)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_class: vac: 1 (threshold
99), anl: 11 (threshold 74)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_constraint: vac: 0
(threshold 50), anl: 2 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_index: vac: 0 (threshold
69), anl: 4 (threshold 60)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_operator: vac: 27 (threshold
191), anl: 50 (threshold 120)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_opfamily: vac: 0 (threshold
64), anl: 4 (threshold 57)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
72), anl: 4 (threshold 61)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
119), anl: 23 (threshold 85)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
99), anl: 16 (threshold 74)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 1 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
74), anl: 17 (threshold 62)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_rewrite: vac: 0 (threshold
67), anl: 1 (threshold 59)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_trigger: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_depend: vac: 42 (threshold
1605), anl: 0 (threshold 828)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_shdepend: vac: 134
(threshold 748), anl: 166 (threshold 399)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: geometry_columns: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: spatial_ref_sys: vac: 0
(threshold 800), anl: 0 (threshold 425)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_toast_1255: vac: 0
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_toast_2618: vac: 0
(threshold 73), anl: 2 (threshold 61)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_toast_2619: vac: 9
(threshold 52), anl: 16 (threshold 51)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_toast_73403: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_toast_73411: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:06 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:06 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:06 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:06 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:06 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:06 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:06 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:06 CET DEBUG: 00000: server process (PID 12599)
exited with exit code 0
2012-02-06 13:39:07 CET DEBUG: 00000: shmem_exit(0): 6 callbacks to
make
2012-02-06 13:39:07 CET DEBUG: 00000: proc_exit(0): 3 callbacks to
make
2012-02-06 13:39:07 CET DEBUG: 00000: SSL: write alert (0x0100)
2012-02-06 13:39:07 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:07 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:07 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:07 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:07 CET DEBUG: 00000: server process (PID 12508)
exited with exit code 0
2012-02-06 13:39:10 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:10 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:10 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:10 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:10 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:10 CET DEBUG: 00000: autovacuum: processing database
"salzburg"
2012-02-06 13:39:10 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:10 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:10 CET DEBUG: 00000: pg_type: vac: 0 (threshold
113), anl: 0 (threshold 82)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_statistic: vac: 0 (threshold
126), anl: 11 (threshold 88)
2012-02-06 13:39:10 CET DEBUG: 00000: sql_features: vac: 0 (threshold
180), anl: 0 (threshold 115)
2012-02-06 13:39:10 CET DEBUG: 00000: sql_implementation_info: vac: 0
(threshold 52), anl: 0 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: sql_languages: vac: 0
(threshold 51), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: sql_packages: vac: 0 (threshold
52), anl: 0 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: sql_parts: vac: 0 (threshold
52), anl: 0 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_database: vac: 2 (threshold
52), anl: 7 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: sql_sizing: vac: 0 (threshold
55), anl: 0 (threshold 52)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_description: vac: 0
(threshold 531), anl: 0 (threshold 290)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 92),
anl: 0 (threshold 71)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_attribute: vac: 0 (threshold
449), anl: 0 (threshold 249)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_proc: vac: 0 (threshold
654), anl: 0 (threshold 352)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_class: vac: 0 (threshold
102), anl: 0 (threshold 76)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_attrdef: vac: 0 (threshold
50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_constraint: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_index: vac: 0 (threshold
71), anl: 0 (threshold 60)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_operator: vac: 0 (threshold
195), anl: 0 (threshold 123)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_opfamily: vac: 0 (threshold
64), anl: 0 (threshold 57)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
73), anl: 0 (threshold 62)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
124), anl: 0 (threshold 87)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
102), anl: 0 (threshold 76)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
77), anl: 0 (threshold 64)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_rewrite: vac: 0 (threshold
67), anl: 0 (threshold 59)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_trigger: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: spatial_ref_sys: vac: 0
(threshold 800), anl: 0 (threshold 425)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_conversion: vac: 0
(threshold 76), anl: 0 (threshold 63)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_depend: vac: 0 (threshold
1611), anl: 0 (threshold 830)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_shdepend: vac: 136
(threshold 920), anl: 168 (threshold 485)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_ts_config: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_ts_config_map: vac: 0
(threshold 111), anl: 0 (threshold 80)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_ts_dict: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_ts_parser: vac: 0 (threshold
50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_ts_template: vac: 0
(threshold 51), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: geometry_columns: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: salzburg: vac: 0 (threshold
8641), anl: 0 (threshold 4346)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_toast_1255: vac: 0
(threshold 51), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_toast_2618: vac: 0
(threshold 73), anl: 0 (threshold 62)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_toast_2619: vac: 23
(threshold 55), anl: 23 (threshold 52)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_toast_32337: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_toast_32345: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_toast_68192: vac: 0
(threshold 3308), anl: 0 (threshold 1679)
2012-02-06 13:39:10 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:10 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:10 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:10 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:10 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:10 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:10 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:10 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:10 CET DEBUG: 00000: server process (PID 12600)
exited with exit code 0
2012-02-06 13:39:15 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET DEBUG: 00000: autovacuum: processing database
"salzburg_osm"
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET DEBUG: 00000: pg_type: vac: 65 (threshold
117), anl: 0 (threshold 84)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_statistic: vac: 58
(threshold 120), anl: 425 (threshold 85)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_database: vac: 2 (threshold
50), anl: 7 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_description: vac: 0
(threshold 531), anl: 7 (threshold 290)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 88),
anl: 19 (threshold 69)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_attribute: vac: 0 (threshold
511), anl: 0 (threshold 280)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_proc: vac: 4 (threshold
654), anl: 46 (threshold 352)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_class: vac: 53 (threshold
108), anl: -21 (threshold 79)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_constraint: vac: 11
(threshold 53), anl: 14 (threshold 52)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_index: vac: 32 (threshold
70), anl: 54 (threshold 60)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_operator: vac: 6 (threshold
191), anl: 45 (threshold 120)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_opfamily: vac: 0 (threshold
64), anl: 7 (threshold 57)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
72), anl: 7 (threshold 61)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
119), anl: 44 (threshold 85)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
99), anl: 34 (threshold 74)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 1 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
74), anl: 17 (threshold 62)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_rewrite: vac: 0 (threshold
67), anl: 1 (threshold 59)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_trigger: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: spatial_ref_sys: vac: 1
(threshold 800), anl: 1 (threshold 425)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_depend: vac: 950 (threshold
1641), anl: 213 (threshold 845)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_shdepend: vac: 136
(threshold 735), anl: 168 (threshold 392)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_ts_config: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_ts_dict: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_ts_parser: vac: 0 (threshold
50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_ts_template: vac: 0
(threshold 51), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: geometry_columns: vac: 40
(threshold 50), anl: 44 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_nodes: vac: 0
(threshold 314667), anl: 0 (threshold 157358)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_ways: vac: 0
(threshold 24767), anl: 0 (threshold 12409)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_rels: vac: 0
(threshold 8064), anl: 0 (threshold 4057)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_polygon: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_roads: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_line: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_point: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_1255: vac: 0
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_2618: vac: 0
(threshold 73), anl: 2 (threshold 61)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_2619: vac: 19
(threshold 52), anl: 43 (threshold 51)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_23923: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_23931: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31892: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31900: vac: 0
(threshold 50), anl: 2 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31909: vac: 0
(threshold 50), anl: 172 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31940: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31942: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31941: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31951: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: forked new backend, pid=12624
socket=9
2012-02-06 13:39:15 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:15 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:15 CET DEBUG: 00000: server process (PID 12623)
exited with exit code 0
2012-02-06 13:39:15 CET DEBUG: 00000: SSL connection from
"(anonymous)"
2012-02-06 13:39:15 CET DEBUG: 00000: received password packet
2012-02-06 13:39:15 CET DEBUG: 00000: postgres child[12624]: starting
with (
2012-02-06 13:39:15 CET DEBUG: 00000: postgres
2012-02-06 13:39:15 CET DEBUG: 00000: -v196608
2012-02-06 13:39:15 CET DEBUG: 00000: -y
2012-02-06 13:39:15 CET DEBUG: 00000: tss_django
2012-02-06 13:39:15 CET DEBUG: 00000: )
2012-02-06 13:39:15 CET DEBUG: 00000: InitPostgres
2012-02-06 13:39:15 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: BEGIN
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:15 CET STATEMENT: BEGIN
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET STATEMENT: BEGIN
2012-02-06 13:39:15 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:15 CET STATEMENT: BEGIN
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: BEGIN
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:15 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:15 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SELECT version()
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SELECT version()
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SELECT postgis_lib_version()
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SELECT postgis_lib_version()
2012-02-06 13:39:15 CET DEBUG: 00000: shmem_exit(0): 6 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: proc_exit(0): 3 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: SSL: write alert (0x0100)
2012-02-06 13:39:15 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:15 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:15 CET DEBUG: 00000: server process (PID 12624)
exited with exit code 0
2012-02-06 13:39:20 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:20 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:20 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:20 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:20 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:20 CET DEBUG: 00000: autovacuum: processing database
"emilia_romagna_osm"
2012-02-06 13:39:20 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:20 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:20 CET DEBUG: 00000: pg_type: vac: 84 (threshold
115), anl: 32 (threshold 82)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_statistic: vac: 13
(threshold 163), anl: 578 (threshold 106)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_database: vac: 2 (threshold
50), anl: 7 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_description: vac: 0
(threshold 531), anl: 0 (threshold 290)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 88),
anl: 19 (threshold 69)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_attribute: vac: 281
(threshold 495), anl: 0 (threshold 273)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_proc: vac: 0 (threshold
654), anl: -3 (threshold 352)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_class: vac: 102 (threshold
104), anl: 37 (threshold 77)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_constraint: vac: 33
(threshold 50), anl: 35 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_index: vac: 28 (threshold
69), anl: 40 (threshold 60)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_operator: vac: 21 (threshold
191), anl: 44 (threshold 120)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_opfamily: vac: 0 (threshold
64), anl: 4 (threshold 57)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
72), anl: 4 (threshold 61)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
119), anl: 23 (threshold 85)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
99), anl: 16 (threshold 74)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 1 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
74), anl: 17 (threshold 62)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_rewrite: vac: 0 (threshold
67), anl: 1 (threshold 59)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_trigger: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: spatial_ref_sys: vac: 0
(threshold 800), anl: 0 (threshold 425)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_depend: vac: 317 (threshold
1605), anl: 315 (threshold 828)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_shdepend: vac: 136
(threshold 925), anl: 168 (threshold 487)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_ts_config: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_ts_dict: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_ts_parser: vac: 0 (threshold
50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_ts_template: vac: 0
(threshold 51), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: geometry_columns: vac: 8
(threshold 50), anl: 12 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: emilia_romagna_osm_polygon:
vac: 0 (threshold 15246), anl: 0 (threshold 7648)
2012-02-06 13:39:20 CET DEBUG: 00000: emilia_romagna_osm_point: vac:
0 (threshold 5224), anl: 0 (threshold 2637)
2012-02-06 13:39:20 CET DEBUG: 00000: emilia_romagna_osm_roads: vac:
0 (threshold 3291), anl: 0 (threshold 1670)
2012-02-06 13:39:20 CET DEBUG: 00000: emilia_romagna_osm_line: vac: 0
(threshold 26778), anl: 0 (threshold 13414)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_1255: vac: 0
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_2618: vac: 0
(threshold 73), anl: 2 (threshold 61)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_2619: vac: 51
(threshold 58), anl: 91 (threshold 54)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_19642: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_19650: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_30255: vac: 0
(threshold 50), anl: 2153 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_29968: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_29976: vac: 0
(threshold 50), anl: 543 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_29984: vac: 0
(threshold 50), anl: 910 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:20 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:20 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:20 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:20 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:20 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:20 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:20 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:20 CET DEBUG: 00000: server process (PID 12625)
exited with exit code 0
2012-02-06 13:39:24 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:24 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:24 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:24 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:24 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:24 CET DEBUG: 00000: autovacuum: processing database
"nyc"
2012-02-06 13:39:24 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:24 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:24 CET DEBUG: 00000: pg_type: vac: 0 (threshold
107), anl: 32 (threshold 78)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_statistic: vac: 31
(threshold 119), anl: 39 (threshold 85)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_database: vac: 2 (threshold
50), anl: 7 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 88),
anl: 19 (threshold 69)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_attribute: vac: 0 (threshold
426), anl: 98 (threshold 238)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_proc: vac: 3 (threshold
654), anl: 0 (threshold 352)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_class: vac: 0 (threshold
99), anl: 15 (threshold 74)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_attrdef: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_constraint: vac: 0
(threshold 50), anl: 6 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_index: vac: 0 (threshold
69), anl: 6 (threshold 60)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_operator: vac: 21 (threshold
191), anl: 44 (threshold 120)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_opfamily: vac: 0 (threshold
64), anl: 4 (threshold 57)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
72), anl: 4 (threshold 61)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
119), anl: 23 (threshold 85)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
99), anl: 16 (threshold 74)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 1 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
74), anl: 17 (threshold 62)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_rewrite: vac: 0 (threshold
67), anl: 1 (threshold 59)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_trigger: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: spatial_ref_sys: vac: 0
(threshold 800), anl: 0 (threshold 425)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_depend: vac: 42 (threshold
1605), anl: 24 (threshold 828)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_shdepend: vac: 136
(threshold 925), anl: 168 (threshold 487)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: geometry_columns: vac: 0
(threshold 50), anl: 1 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: nyc_buildings: vac: 0
(threshold 1355), anl: 0 (threshold 703)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_toast_1255: vac: 0
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_toast_2618: vac: 0
(threshold 73), anl: 2 (threshold 61)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_toast_2619: vac: 2
(threshold 52), anl: 14 (threshold 51)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_toast_18675: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_toast_18683: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_toast_19260: vac: 0
(threshold 50), anl: 22 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:24 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:24 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:24 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:24 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:24 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:24 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:24 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:24 CET DEBUG: 00000: server process (PID 12628)
exited with exit code 0
2012-02-06 13:39:25 CET DEBUG: 00000: forked new backend, pid=12629
socket=9
2012-02-06 13:39:25 CET DEBUG: 00000: SSL connection from
"(anonymous)"
2012-02-06 13:39:25 CET DEBUG: 00000: received password packet
2012-02-06 13:39:25 CET DEBUG: 00000: postgres child[12629]: starting
with (
2012-02-06 13:39:25 CET DEBUG: 00000: postgres
2012-02-06 13:39:25 CET DEBUG: 00000: -v196608
2012-02-06 13:39:25 CET DEBUG: 00000: -y
2012-02-06 13:39:25 CET DEBUG: 00000: tss_land_cover
2012-02-06 13:39:25 CET DEBUG: 00000: )
2012-02-06 13:39:25 CET DEBUG: 00000: InitPostgres
2012-02-06 13:39:25 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SELECT postgis_lib_version()
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SELECT postgis_lib_version()
2012-02-06 13:39:25 CET DEBUG: 00000: shmem_exit(0): 6 callbacks to
make
2012-02-06 13:39:25 CET DEBUG: 00000: proc_exit(0): 3 callbacks to
make
2012-02-06 13:39:25 CET DEBUG: 00000: SSL: write alert (0x0100)
2012-02-06 13:39:25 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:25 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:25 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:25 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:25 CET DEBUG: 00000: server process (PID 12629)
exited with exit code 0
2012-02-06 13:39:25 CET DEBUG: 00000: forked new backend, pid=12630
socket=9
2012-02-06 13:39:25 CET DEBUG: 00000: SSL connection from
"(anonymous)"
2012-02-06 13:39:25 CET DEBUG: 00000: received password packet
2012-02-06 13:39:25 CET DEBUG: 00000: postgres child[12630]: starting
with (
2012-02-06 13:39:25 CET DEBUG: 00000: postgres
2012-02-06 13:39:25 CET DEBUG: 00000: -v196608
2012-02-06 13:39:25 CET DEBUG: 00000: -y
2012-02-06 13:39:25 CET DEBUG: 00000: tss_land_cover
2012-02-06 13:39:25 CET DEBUG: 00000: )
2012-02-06 13:39:25 CET DEBUG: 00000: InitPostgres
2012-02-06 13:39:25 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: CREATE TABLE
"tss_salzburg_lc" ("id" serial NOT NULL PRIMARY KEY);
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: CREATE TABLE
"tss_salzburg_lc" ("id" serial NOT NULL PRIMARY KEY);
2012-02-06 13:39:25 CET NOTICE: 00000: CREATE TABLE will create
implicit sequence "tss_salzburg_lc_id_seq" for serial column
"tss_salzburg_lc.id"
2012-02-06 13:39:25 CET STATEMENT: CREATE TABLE
"tss_salzburg_lc" ("id" serial NOT NULL PRIMARY KEY);
2012-02-06 13:39:25 CET NOTICE: 00000: CREATE TABLE / PRIMARY KEY
will create implicit index "tss_salzburg_lc_pkey" for table
"tss_salzburg_lc"
2012-02-06 13:39:25 CET STATEMENT: CREATE TABLE
"tss_salzburg_lc" ("id" serial NOT NULL PRIMARY KEY);
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: CREATE TABLE
"tss_salzburg_lc" ("id" serial NOT NULL PRIMARY KEY);
2012-02-06 13:39:28 CET DEBUG: 00000: shmem_exit(0): 6 callbacks to
make
2012-02-06 13:39:28 CET DEBUG: 00000: proc_exit(0): 3 callbacks to
make
2012-02-06 13:39:28 CET DEBUG: 00000: SSL: write alert (0x0100)
2012-02-06 13:39:28 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:28 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:28 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:28 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:28 CET DEBUG: 00000: server process (PID 12630)
exited with exit code 0
2012-02-06 13:39:29 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:29 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:29 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:29 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:29 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:29 CET DEBUG: 00000: autovacuum: processing database
"geojsontest"
2012-02-06 13:39:29 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:29 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:29 CET DEBUG: 00000: pg_type: vac: 4 (threshold
107), anl: 39 (threshold 78)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_statistic: vac: 43
(threshold 119), anl: 53 (threshold 85)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_database: vac: 2 (threshold
50), anl: 7 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_description: vac: 0
(threshold 531), anl: 0 (threshold 290)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 88),
anl: 19 (threshold 69)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_attribute: vac: 40
(threshold 426), anl: 174 (threshold 238)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_proc: vac: 0 (threshold
654), anl: -3 (threshold 352)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_class: vac: 9 (threshold
99), anl: 29 (threshold 74)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_attrdef: vac: 1 (threshold
50), anl: 2 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_constraint: vac: 4
(threshold 50), anl: 14 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_index: vac: 2 (threshold
69), anl: 11 (threshold 60)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_operator: vac: 21 (threshold
191), anl: 44 (threshold 120)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_opfamily: vac: 0 (threshold
64), anl: 4 (threshold 57)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
72), anl: 4 (threshold 61)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
119), anl: 23 (threshold 85)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
99), anl: 16 (threshold 74)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 1 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
74), anl: 17 (threshold 62)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_rewrite: vac: 0 (threshold
67), anl: 1 (threshold 59)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_trigger: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: spatial_ref_sys: vac: 0
(threshold 800), anl: 0 (threshold 425)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_depend: vac: 66 (threshold
1605), anl: 69 (threshold 828)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_shdepend: vac: 138
(threshold 919), anl: 170 (threshold 485)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_ts_config: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_ts_dict: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_ts_parser: vac: 0 (threshold
50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_ts_template: vac: 0
(threshold 51), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: geometry_columns: vac: 1
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: italynature: vac: 0 (threshold
2434), anl: 0 (threshold 1242)
2012-02-06 13:39:29 CET DEBUG: 00000: salzburg: vac: 0 (threshold
50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_1255: vac: 0
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_2618: vac: 0
(threshold 73), anl: 2 (threshold 61)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_2619: vac: 5
(threshold 52), anl: 15 (threshold 51)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_16937: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_16945: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_17921: vac: 0
(threshold 50), anl: 986 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_73032: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:29 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:29 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:29 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:29 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:29 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:29 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:29 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:29 CET DEBUG: 00000: server process (PID 12632)
exited with exit code 0
with "LOCATION" tag:
2012-02-06 13:39:01 CET DEBUG: 00000: my backend id is 2
2012-02-06 13:39:01 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:01 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:01 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:01 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:01 CET DEBUG: 00000: autovacuum: processing database
"tss_land_cover"
2012-02-06 13:39:01 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:01 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:01 CET DEBUG: 00000: pg_type: vac: 24 (threshold
113), anl: 24 (threshold 81)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_statistic: vac: 92
(threshold 120), anl: 444 (threshold 85)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_database: vac: 2 (threshold
50), anl: 7 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 88),
anl: 0 (threshold 69)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_attribute: vac: 285
(threshold 514), anl: 247 (threshold 282)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_proc: vac: 0 (threshold
654), anl: 0 (threshold 352)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_class: vac: 27 (threshold
101), anl: 27 (threshold 75)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_attrdef: vac: 24 (threshold
50), anl: 24 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_constraint: vac: 2
(threshold 51), anl: 2 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_index: vac: 7 (threshold
70), anl: 7 (threshold 60)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_operator: vac: 0 (threshold
191), anl: 0 (threshold 120)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
72), anl: 0 (threshold 61)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
119), anl: 0 (threshold 85)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
99), anl: 0 (threshold 74)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
74), anl: 0 (threshold 62)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_trigger: vac: 44 (threshold
51), anl: 40 (threshold 51)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_depend: vac: 1443 (threshold
1649), anl: 529 (threshold 849)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_shdepend: vac: 134
(threshold 748), anl: 166 (threshold 399)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: geometry_columns: vac: 2
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:01 CET DEBUG: 00000: spatial_ref_sys: vac: 0
(threshold 800), anl: 0 (threshold 425)
2012-02-06 13:39:01 CET DEBUG: 00000: pg_toast_2619: vac: 12
(threshold 52), anl: 12 (threshold 51)
2012-02-06 13:39:01 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:01 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:01 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:01 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:01 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:01 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:01 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:01 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:01 CET DEBUG: 00000: server process (PID 12598)
exited with exit code 0
2012-02-06 13:39:06 CET DEBUG: 00000: my backend id is 2
2012-02-06 13:39:06 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:06 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:06 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:06 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:06 CET DEBUG: 00000: autovacuum: processing database
"template_postgis"
2012-02-06 13:39:06 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:06 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:06 CET DEBUG: 00000: pg_type: vac: 9 (threshold
107), anl: 37 (threshold 78)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_statistic: vac: 36
(threshold 119), anl: 41 (threshold 85)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_database: vac: 2 (threshold
50), anl: 7 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 88),
anl: 19 (threshold 69)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_attribute: vac: 0 (threshold
426), anl: 61 (threshold 238)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_proc: vac: 3 (threshold
654), anl: 0 (threshold 352)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_class: vac: 1 (threshold
99), anl: 11 (threshold 74)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_constraint: vac: 0
(threshold 50), anl: 2 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_index: vac: 0 (threshold
69), anl: 4 (threshold 60)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_operator: vac: 27 (threshold
191), anl: 50 (threshold 120)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_opfamily: vac: 0 (threshold
64), anl: 4 (threshold 57)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
72), anl: 4 (threshold 61)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
119), anl: 23 (threshold 85)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
99), anl: 16 (threshold 74)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 1 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
74), anl: 17 (threshold 62)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_rewrite: vac: 0 (threshold
67), anl: 1 (threshold 59)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_trigger: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_depend: vac: 42 (threshold
1605), anl: 0 (threshold 828)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_shdepend: vac: 134
(threshold 748), anl: 166 (threshold 399)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: geometry_columns: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: spatial_ref_sys: vac: 0
(threshold 800), anl: 0 (threshold 425)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_toast_1255: vac: 0
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_toast_2618: vac: 0
(threshold 73), anl: 2 (threshold 61)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_toast_2619: vac: 9
(threshold 52), anl: 16 (threshold 51)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_toast_73403: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: pg_toast_73411: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:06 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:06 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:06 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:06 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:06 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:06 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:06 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:06 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:06 CET DEBUG: 00000: server process (PID 12599)
exited with exit code 0
2012-02-06 13:39:07 CET DEBUG: 00000: shmem_exit(0): 6 callbacks to
make
2012-02-06 13:39:07 CET DEBUG: 00000: proc_exit(0): 3 callbacks to
make
2012-02-06 13:39:07 CET DEBUG: 00000: SSL: write alert (0x0100)
2012-02-06 13:39:07 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:07 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:07 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:07 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:07 CET DEBUG: 00000: server process (PID 12508)
exited with exit code 0
2012-02-06 13:39:10 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:10 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:10 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:10 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:10 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:10 CET DEBUG: 00000: autovacuum: processing database
"salzburg"
2012-02-06 13:39:10 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:10 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:10 CET DEBUG: 00000: pg_type: vac: 0 (threshold
113), anl: 0 (threshold 82)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_statistic: vac: 0 (threshold
126), anl: 11 (threshold 88)
2012-02-06 13:39:10 CET DEBUG: 00000: sql_features: vac: 0 (threshold
180), anl: 0 (threshold 115)
2012-02-06 13:39:10 CET DEBUG: 00000: sql_implementation_info: vac: 0
(threshold 52), anl: 0 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: sql_languages: vac: 0
(threshold 51), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: sql_packages: vac: 0 (threshold
52), anl: 0 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: sql_parts: vac: 0 (threshold
52), anl: 0 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_database: vac: 2 (threshold
52), anl: 7 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: sql_sizing: vac: 0 (threshold
55), anl: 0 (threshold 52)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_description: vac: 0
(threshold 531), anl: 0 (threshold 290)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 92),
anl: 0 (threshold 71)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_attribute: vac: 0 (threshold
449), anl: 0 (threshold 249)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_proc: vac: 0 (threshold
654), anl: 0 (threshold 352)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_class: vac: 0 (threshold
102), anl: 0 (threshold 76)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_attrdef: vac: 0 (threshold
50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_constraint: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_index: vac: 0 (threshold
71), anl: 0 (threshold 60)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_operator: vac: 0 (threshold
195), anl: 0 (threshold 123)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_opfamily: vac: 0 (threshold
64), anl: 0 (threshold 57)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
73), anl: 0 (threshold 62)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
124), anl: 0 (threshold 87)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
102), anl: 0 (threshold 76)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
77), anl: 0 (threshold 64)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_rewrite: vac: 0 (threshold
67), anl: 0 (threshold 59)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_trigger: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: spatial_ref_sys: vac: 0
(threshold 800), anl: 0 (threshold 425)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_conversion: vac: 0
(threshold 76), anl: 0 (threshold 63)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_depend: vac: 0 (threshold
1611), anl: 0 (threshold 830)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_shdepend: vac: 136
(threshold 920), anl: 168 (threshold 485)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_ts_config: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_ts_config_map: vac: 0
(threshold 111), anl: 0 (threshold 80)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_ts_dict: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_ts_parser: vac: 0 (threshold
50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_ts_template: vac: 0
(threshold 51), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: geometry_columns: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: salzburg: vac: 0 (threshold
8641), anl: 0 (threshold 4346)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_toast_1255: vac: 0
(threshold 51), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_toast_2618: vac: 0
(threshold 73), anl: 0 (threshold 62)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_toast_2619: vac: 23
(threshold 55), anl: 23 (threshold 52)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_toast_32337: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_toast_32345: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:10 CET DEBUG: 00000: pg_toast_68192: vac: 0
(threshold 3308), anl: 0 (threshold 1679)
2012-02-06 13:39:10 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:10 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:10 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:10 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:10 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:10 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:10 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:10 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:10 CET DEBUG: 00000: server process (PID 12600)
exited with exit code 0
2012-02-06 13:39:15 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET DEBUG: 00000: autovacuum: processing database
"salzburg_osm"
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET DEBUG: 00000: pg_type: vac: 65 (threshold
117), anl: 0 (threshold 84)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_statistic: vac: 58
(threshold 120), anl: 425 (threshold 85)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_database: vac: 2 (threshold
50), anl: 7 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_description: vac: 0
(threshold 531), anl: 7 (threshold 290)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 88),
anl: 19 (threshold 69)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_attribute: vac: 0 (threshold
511), anl: 0 (threshold 280)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_proc: vac: 4 (threshold
654), anl: 46 (threshold 352)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_class: vac: 53 (threshold
108), anl: -21 (threshold 79)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_constraint: vac: 11
(threshold 53), anl: 14 (threshold 52)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_index: vac: 32 (threshold
70), anl: 54 (threshold 60)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_operator: vac: 6 (threshold
191), anl: 45 (threshold 120)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_opfamily: vac: 0 (threshold
64), anl: 7 (threshold 57)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
72), anl: 7 (threshold 61)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
119), anl: 44 (threshold 85)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
99), anl: 34 (threshold 74)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 1 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
74), anl: 17 (threshold 62)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_rewrite: vac: 0 (threshold
67), anl: 1 (threshold 59)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_trigger: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: spatial_ref_sys: vac: 1
(threshold 800), anl: 1 (threshold 425)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_depend: vac: 950 (threshold
1641), anl: 213 (threshold 845)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_shdepend: vac: 136
(threshold 735), anl: 168 (threshold 392)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_ts_config: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_ts_dict: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_ts_parser: vac: 0 (threshold
50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_ts_template: vac: 0
(threshold 51), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: geometry_columns: vac: 40
(threshold 50), anl: 44 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_nodes: vac: 0
(threshold 314667), anl: 0 (threshold 157358)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_ways: vac: 0
(threshold 24767), anl: 0 (threshold 12409)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_rels: vac: 0
(threshold 8064), anl: 0 (threshold 4057)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_polygon: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_roads: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_line: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: salzburg_osm_point: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_1255: vac: 0
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_2618: vac: 0
(threshold 73), anl: 2 (threshold 61)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_2619: vac: 19
(threshold 52), anl: 43 (threshold 51)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_23923: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_23931: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31892: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31900: vac: 0
(threshold 50), anl: 2 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31909: vac: 0
(threshold 50), anl: 172 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31940: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31942: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31941: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: pg_toast_31951: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: forked new backend, pid=12624
socket=9
2012-02-06 13:39:15 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:15 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:15 CET DEBUG: 00000: server process (PID 12623)
exited with exit code 0
2012-02-06 13:39:15 CET DEBUG: 00000: SSL connection from
"(anonymous)"
2012-02-06 13:39:15 CET DEBUG: 00000: received password packet
2012-02-06 13:39:15 CET DEBUG: 00000: postgres child[12624]: starting
with (
2012-02-06 13:39:15 CET DEBUG: 00000: postgres
2012-02-06 13:39:15 CET DEBUG: 00000: -v196608
2012-02-06 13:39:15 CET DEBUG: 00000: -y
2012-02-06 13:39:15 CET DEBUG: 00000: tss_django
2012-02-06 13:39:15 CET DEBUG: 00000: )
2012-02-06 13:39:15 CET DEBUG: 00000: InitPostgres
2012-02-06 13:39:15 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: BEGIN
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:15 CET STATEMENT: BEGIN
2012-02-06 13:39:15 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:15 CET STATEMENT: BEGIN
2012-02-06 13:39:15 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:15 CET STATEMENT: BEGIN
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: BEGIN
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:15 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:15 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SELECT version()
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SELECT version()
2012-02-06 13:39:15 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SELECT postgis_lib_version()
2012-02-06 13:39:15 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:15 CET STATEMENT: SELECT postgis_lib_version()
2012-02-06 13:39:15 CET DEBUG: 00000: shmem_exit(0): 6 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: proc_exit(0): 3 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: SSL: write alert (0x0100)
2012-02-06 13:39:15 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:15 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:15 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:15 CET DEBUG: 00000: server process (PID 12624)
exited with exit code 0
2012-02-06 13:39:20 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:20 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:20 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:20 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:20 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:20 CET DEBUG: 00000: autovacuum: processing database
"emilia_romagna_osm"
2012-02-06 13:39:20 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:20 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:20 CET DEBUG: 00000: pg_type: vac: 84 (threshold
115), anl: 32 (threshold 82)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_statistic: vac: 13
(threshold 163), anl: 578 (threshold 106)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_database: vac: 2 (threshold
50), anl: 7 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_description: vac: 0
(threshold 531), anl: 0 (threshold 290)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 88),
anl: 19 (threshold 69)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_attribute: vac: 281
(threshold 495), anl: 0 (threshold 273)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_proc: vac: 0 (threshold
654), anl: -3 (threshold 352)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_class: vac: 102 (threshold
104), anl: 37 (threshold 77)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_constraint: vac: 33
(threshold 50), anl: 35 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_index: vac: 28 (threshold
69), anl: 40 (threshold 60)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_operator: vac: 21 (threshold
191), anl: 44 (threshold 120)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_opfamily: vac: 0 (threshold
64), anl: 4 (threshold 57)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
72), anl: 4 (threshold 61)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
119), anl: 23 (threshold 85)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
99), anl: 16 (threshold 74)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 1 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
74), anl: 17 (threshold 62)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_rewrite: vac: 0 (threshold
67), anl: 1 (threshold 59)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_trigger: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: spatial_ref_sys: vac: 0
(threshold 800), anl: 0 (threshold 425)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_depend: vac: 317 (threshold
1605), anl: 315 (threshold 828)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_shdepend: vac: 136
(threshold 925), anl: 168 (threshold 487)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_ts_config: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_ts_dict: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_ts_parser: vac: 0 (threshold
50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_ts_template: vac: 0
(threshold 51), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: geometry_columns: vac: 8
(threshold 50), anl: 12 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: emilia_romagna_osm_polygon:
vac: 0 (threshold 15246), anl: 0 (threshold 7648)
2012-02-06 13:39:20 CET DEBUG: 00000: emilia_romagna_osm_point: vac:
0 (threshold 5224), anl: 0 (threshold 2637)
2012-02-06 13:39:20 CET DEBUG: 00000: emilia_romagna_osm_roads: vac:
0 (threshold 3291), anl: 0 (threshold 1670)
2012-02-06 13:39:20 CET DEBUG: 00000: emilia_romagna_osm_line: vac: 0
(threshold 26778), anl: 0 (threshold 13414)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_1255: vac: 0
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_2618: vac: 0
(threshold 73), anl: 2 (threshold 61)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_2619: vac: 51
(threshold 58), anl: 91 (threshold 54)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_19642: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_19650: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_30255: vac: 0
(threshold 50), anl: 2153 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_29968: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_29976: vac: 0
(threshold 50), anl: 543 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: pg_toast_29984: vac: 0
(threshold 50), anl: 910 (threshold 50)
2012-02-06 13:39:20 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:20 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:20 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:20 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:20 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:20 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:20 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:20 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:20 CET DEBUG: 00000: server process (PID 12625)
exited with exit code 0
2012-02-06 13:39:24 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:24 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:24 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:24 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:24 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:24 CET DEBUG: 00000: autovacuum: processing database
"nyc"
2012-02-06 13:39:24 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:24 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:24 CET DEBUG: 00000: pg_type: vac: 0 (threshold
107), anl: 32 (threshold 78)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_statistic: vac: 31
(threshold 119), anl: 39 (threshold 85)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_database: vac: 2 (threshold
50), anl: 7 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 88),
anl: 19 (threshold 69)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_attribute: vac: 0 (threshold
426), anl: 98 (threshold 238)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_proc: vac: 3 (threshold
654), anl: 0 (threshold 352)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_class: vac: 0 (threshold
99), anl: 15 (threshold 74)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_attrdef: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_constraint: vac: 0
(threshold 50), anl: 6 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_index: vac: 0 (threshold
69), anl: 6 (threshold 60)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_operator: vac: 21 (threshold
191), anl: 44 (threshold 120)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_opfamily: vac: 0 (threshold
64), anl: 4 (threshold 57)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
72), anl: 4 (threshold 61)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
119), anl: 23 (threshold 85)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
99), anl: 16 (threshold 74)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 1 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
74), anl: 17 (threshold 62)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_rewrite: vac: 0 (threshold
67), anl: 1 (threshold 59)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_trigger: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: spatial_ref_sys: vac: 0
(threshold 800), anl: 0 (threshold 425)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_depend: vac: 42 (threshold
1605), anl: 24 (threshold 828)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_shdepend: vac: 136
(threshold 925), anl: 168 (threshold 487)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: geometry_columns: vac: 0
(threshold 50), anl: 1 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: nyc_buildings: vac: 0
(threshold 1355), anl: 0 (threshold 703)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_toast_1255: vac: 0
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_toast_2618: vac: 0
(threshold 73), anl: 2 (threshold 61)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_toast_2619: vac: 2
(threshold 52), anl: 14 (threshold 51)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_toast_18675: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_toast_18683: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: pg_toast_19260: vac: 0
(threshold 50), anl: 22 (threshold 50)
2012-02-06 13:39:24 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:24 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:24 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:24 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:24 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:24 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:24 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:24 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:24 CET DEBUG: 00000: server process (PID 12628)
exited with exit code 0
2012-02-06 13:39:25 CET DEBUG: 00000: forked new backend, pid=12629
socket=9
2012-02-06 13:39:25 CET DEBUG: 00000: SSL connection from
"(anonymous)"
2012-02-06 13:39:25 CET DEBUG: 00000: received password packet
2012-02-06 13:39:25 CET DEBUG: 00000: postgres child[12629]: starting
with (
2012-02-06 13:39:25 CET DEBUG: 00000: postgres
2012-02-06 13:39:25 CET DEBUG: 00000: -v196608
2012-02-06 13:39:25 CET DEBUG: 00000: -y
2012-02-06 13:39:25 CET DEBUG: 00000: tss_land_cover
2012-02-06 13:39:25 CET DEBUG: 00000: )
2012-02-06 13:39:25 CET DEBUG: 00000: InitPostgres
2012-02-06 13:39:25 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SELECT postgis_lib_version()
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SELECT postgis_lib_version()
2012-02-06 13:39:25 CET DEBUG: 00000: shmem_exit(0): 6 callbacks to
make
2012-02-06 13:39:25 CET DEBUG: 00000: proc_exit(0): 3 callbacks to
make
2012-02-06 13:39:25 CET DEBUG: 00000: SSL: write alert (0x0100)
2012-02-06 13:39:25 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:25 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:25 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:25 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:25 CET DEBUG: 00000: server process (PID 12629)
exited with exit code 0
2012-02-06 13:39:25 CET DEBUG: 00000: forked new backend, pid=12630
socket=9
2012-02-06 13:39:25 CET DEBUG: 00000: SSL connection from
"(anonymous)"
2012-02-06 13:39:25 CET DEBUG: 00000: received password packet
2012-02-06 13:39:25 CET DEBUG: 00000: postgres child[12630]: starting
with (
2012-02-06 13:39:25 CET DEBUG: 00000: postgres
2012-02-06 13:39:25 CET DEBUG: 00000: -v196608
2012-02-06 13:39:25 CET DEBUG: 00000: -y
2012-02-06 13:39:25 CET DEBUG: 00000: tss_land_cover
2012-02-06 13:39:25 CET DEBUG: 00000: )
2012-02-06 13:39:25 CET DEBUG: 00000: InitPostgres
2012-02-06 13:39:25 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SHOW default_transaction_isolation
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: SET default_transaction_isolation
TO 'read uncommitted'
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: BEGIN
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: SET TIME ZONE E'America/Chicago'
2012-02-06 13:39:25 CET DEBUG: 00000: StartTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: CREATE TABLE
"tss_salzburg_lc" ("id" serial NOT NULL PRIMARY KEY);
2012-02-06 13:39:25 CET DEBUG: 00000: ProcessUtility
2012-02-06 13:39:25 CET STATEMENT: CREATE TABLE
"tss_salzburg_lc" ("id" serial NOT NULL PRIMARY KEY);
2012-02-06 13:39:25 CET NOTICE: 00000: CREATE TABLE will create
implicit sequence "tss_salzburg_lc_id_seq" for serial column
"tss_salzburg_lc.id"
2012-02-06 13:39:25 CET STATEMENT: CREATE TABLE
"tss_salzburg_lc" ("id" serial NOT NULL PRIMARY KEY);
2012-02-06 13:39:25 CET NOTICE: 00000: CREATE TABLE / PRIMARY KEY
will create implicit index "tss_salzburg_lc_pkey" for table
"tss_salzburg_lc"
2012-02-06 13:39:25 CET STATEMENT: CREATE TABLE
"tss_salzburg_lc" ("id" serial NOT NULL PRIMARY KEY);
2012-02-06 13:39:25 CET DEBUG: 00000: CommitTransactionCommand
2012-02-06 13:39:25 CET STATEMENT: CREATE TABLE
"tss_salzburg_lc" ("id" serial NOT NULL PRIMARY KEY);
2012-02-06 13:39:28 CET DEBUG: 00000: shmem_exit(0): 6 callbacks to
make
2012-02-06 13:39:28 CET DEBUG: 00000: proc_exit(0): 3 callbacks to
make
2012-02-06 13:39:28 CET DEBUG: 00000: SSL: write alert (0x0100)
2012-02-06 13:39:28 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:28 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:28 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:28 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:28 CET DEBUG: 00000: server process (PID 12630)
exited with exit code 0
2012-02-06 13:39:29 CET DEBUG: 00000: my backend id is 1
2012-02-06 13:39:29 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:29 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:29 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:29 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:29 CET DEBUG: 00000: autovacuum: processing database
"geojsontest"
2012-02-06 13:39:29 CET DEBUG: 00000: StartTransaction
2012-02-06 13:39:29 CET DEBUG: 00000: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:29 CET DEBUG: 00000: pg_type: vac: 4 (threshold
107), anl: 39 (threshold 78)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_statistic: vac: 43
(threshold 119), anl: 53 (threshold 85)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_authid: vac: 0 (threshold
50), anl: 1 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_database: vac: 2 (threshold
50), anl: 7 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_description: vac: 0
(threshold 531), anl: 0 (threshold 290)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_cast: vac: 0 (threshold 88),
anl: 19 (threshold 69)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_namespace: vac: 0 (threshold
51), anl: 0 (threshold 51)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_attribute: vac: 40
(threshold 426), anl: 174 (threshold 238)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_proc: vac: 0 (threshold
654), anl: -3 (threshold 352)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_class: vac: 9 (threshold
99), anl: 29 (threshold 74)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_attrdef: vac: 1 (threshold
50), anl: 2 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_constraint: vac: 4
(threshold 50), anl: 14 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_index: vac: 2 (threshold
69), anl: 11 (threshold 60)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_operator: vac: 21 (threshold
191), anl: 44 (threshold 120)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_opfamily: vac: 0 (threshold
64), anl: 4 (threshold 57)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_opclass: vac: 0 (threshold
72), anl: 4 (threshold 61)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_am: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_amop: vac: 0 (threshold
119), anl: 23 (threshold 85)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_amproc: vac: 0 (threshold
99), anl: 16 (threshold 74)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_language: vac: 0 (threshold
51), anl: 1 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_aggregate: vac: 0 (threshold
74), anl: 17 (threshold 62)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_rewrite: vac: 0 (threshold
67), anl: 1 (threshold 59)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_trigger: vac: 0 (threshold
51), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: spatial_ref_sys: vac: 0
(threshold 800), anl: 0 (threshold 425)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_depend: vac: 66 (threshold
1605), anl: 69 (threshold 828)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_tablespace: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_pltemplate: vac: 0
(threshold 51), anl: 0 (threshold 51)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_shdepend: vac: 138
(threshold 919), anl: 170 (threshold 485)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_shdescription: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_ts_config: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_ts_dict: vac: 0 (threshold
53), anl: 0 (threshold 52)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_ts_parser: vac: 0 (threshold
50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_ts_template: vac: 0
(threshold 51), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_auth_members: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: geometry_columns: vac: 1
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: italynature: vac: 0 (threshold
2434), anl: 0 (threshold 1242)
2012-02-06 13:39:29 CET DEBUG: 00000: salzburg: vac: 0 (threshold
50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_1255: vac: 0
(threshold 50), anl: 3 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_2618: vac: 0
(threshold 73), anl: 2 (threshold 61)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_2619: vac: 5
(threshold 52), anl: 15 (threshold 51)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_16937: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_16945: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_17921: vac: 0
(threshold 50), anl: 986 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: pg_toast_73032: vac: 0
(threshold 50), anl: 0 (threshold 50)
2012-02-06 13:39:29 CET DEBUG: 00000: CommitTransaction
2012-02-06 13:39:29 CET DEBUG: 00000: name: unnamed;
blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2012-02-06 13:39:29 CET DEBUG: 00000: shmem_exit(0): 7 callbacks to
make
2012-02-06 13:39:29 CET DEBUG: 00000: proc_exit(0): 2 callbacks to
make
2012-02-06 13:39:29 CET DEBUG: 00000: exit(0)
2012-02-06 13:39:29 CET DEBUG: 00000: shmem_exit(-1): 0 callbacks to
make
2012-02-06 13:39:29 CET DEBUG: 00000: proc_exit(-1): 0 callbacks to
make
2012-02-06 13:39:29 CET DEBUG: 00000: reaping dead processes
2012-02-06 13:39:29 CET DEBUG: 00000: server process (PID 12632)
exited with exit code 0
Andrew Godwin
Feb 6, 2012, 11:06:20 AM2/6/12
to south...@googlegroups.com
On 06/02/12 12:45, Alessandro Candini wrote:
> I've used the maximum verbosity of postgresql logging, deleting lines
> with "LOCATION" tag:
> I've used the maximum verbosity of postgresql logging, deleting lines
> with "LOCATION" tag:
Hmm, that log clearly shows Postgres receiving a CREATE TABLE and then a
COMMIT, so South is sending the right thing - not sure what else I can
do. It must be a database issue.
Andrew
Reply all
Reply to author
Forward
0 new messages