I'm trying to retrieve a big query (bah, not so big, but with a dozen of
joins) and all I get is this:
010112.17:22:06.050 [5387] DEBUG: Rel trabajos_docentes: Pages: 3 --> 2.
010112.17:30:48.458 [5412] DEBUG: geqo_params: ga parameter file
'/var/lib/pgsql/data/pg_geqo'
does not exist or permissions are not setup correctly
010112.17:30:48.475 [5412] DEBUG: geqo_params: no pool size specified;
using computed value of 1024
010112.17:30:48.475 [5412] DEBUG: geqo_params: no optimization effort
specified;
using value of 40
010112.17:30:48.475 [5412] DEBUG: geqo_params: no number of trials
specified;
using computed value of 400
010112.17:30:48.475 [5412] DEBUG: geqo_params: no random seed specified;
using computed value of 979331448
010112.17:30:48.475 [5412] DEBUG: geqo_params: no selection bias specified;
using default value of 2.000000
010112.17:30:57.936 [5412] DEBUG: geqo_main: using edge recombination
crossover [ERX]
Now, when I go to /var/lib/pgsql/data/ I see this:
total 100
-rw------- 1 postgres postgres 4 Dec 5 12:10 PG_VERSION
drwx------ 5 postgres postgres 1024 Dec 19 17:41 base/
-rw------- 1 postgres postgres 8192 Jan 12 15:30 pg_control
-rw------- 1 postgres postgres 8192 Jan 12 17:22 pg_database
-r-------- 1 postgres postgres 3407 Dec 5 12:10 pg_geqo.sample
-rw------- 1 postgres postgres 0 Dec 5 12:10 pg_group
-rw------- 1 postgres postgres 16384 Dec 5 12:10 pg_group_name_index
-rw------- 1 postgres postgres 16384 Dec 5 12:10 pg_group_sysid_index
-r-------- 1 postgres postgres 5729 Dec 5 12:10 pg_hba.conf
-rw------- 1 postgres postgres 16384 Jan 12 17:22 pg_log
-rw------- 1 postgres postgres 58 Dec 16 17:03 pg_pwd
-rw------- 1 postgres postgres 0 Dec 16 17:03 pg_pwd.reload
-rw------- 1 postgres postgres 8192 Dec 16 17:03 pg_shadow
-rw------- 1 postgres postgres 8192 Jan 12 17:22 pg_variable
drwx------ 2 postgres postgres 1024 Dec 5 12:10 pg_xlog/
-rw------- 1 postgres postgres 87 Jan 12 15:30 postmaster.opts
-r-------- 1 postgres postgres 4 Dec 5 12:10 postmaster.opts.default
-rw------- 1 postgres postgres 4 Jan 12 15:30 postmaster.pid
as you can see, there is a pg_geqo.sample, but not a pg_geqo. Should I rename
it for it to work? I have been making lots of querys (inserts and selects)
with no problem at all.
Any help will be appretiated.
--
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Martín Marqués email: martin@math.unl.edu.ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------
