Gracias por la ayuda,
Te cuento un poco mas, los inserts vienen desde el servidor web que esta ahi mismo, por lo que el cambio del set time zone, no puedo hacerlo.
Te copio el fragmento del postgresql.conf, en el cual esta seteadas las opciones
Cita:
#------------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#------------------------------------------------------------------------------
# - Statement Behavior -
#search_path = '"$user",public' # schema names
#default_tablespace = '' # a tablespace name, '' uses the default
#temp_tablespaces = '' # a list of tablespace names, '' uses
# only default tablespace
#check_function_bodies = on
#default_transaction_isolation = 'read committed'
#default_transaction_read_only = off
#session_replication_role = 'origin'
#statement_timeout = 0 # 0 is disabled
#vacuum_freeze_min_age = 100000000
#xmlbinary = 'base64'
#xmloption = 'content'
# - Locale and Formatting -
#datestyle = 'iso, dmy'
#datestyle = 'SQL, DMY'
datestyle = 'iso, dmy'
timezone = 'America/Guayaquil'
#timezone = 'default'
#timezone = unknown # actually, defaults to TZ environment
# setting
#timezone_abbreviations = 'Default' # Select the set of available time zone
# abbreviations. Currently, there are
# Default
# Australia
# India
# You can create your own file in
# share/timezonesets/.
#extra_float_digits = 0 # min -15, max 2
#client_encoding = sql_ascii # actually, defaults to database
# encoding
# These settings are initialized by initdb, but they can be changed.
lc_messages = 'es_ES.UTF-8' # locale for system error message
# strings
lc_monetary = 'es_ES.UTF-8' # locale for monetary formatting
lc_numeric = 'es_ES.UTF-8' # locale for number formatting
lc_time = 'es_ES.UTF-8' # locale for time formatting
# default configuration for text search
default_text_search_config = 'pg_catalog.spanish'
# - Other Defaults -
#explain_pretty_print = on
#dynamic_library_path = '$libdir'
#local_preload_libraries = ''
Prefiero reiniciar el servidor que solo el servicio ya que como lo hice a mano, no confio mucho jejeje. este es el script en /etc/init.d/postgresql
Cita: case "$1" in
'start')
sudo -u postgres /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
echo "Base de Datos iniciada"
;;
'stop')
#kill `cat /usr/local/pgsql/data/postmaster.pid`
killproc /usr/local/pgsql/data/postmaster.pid
;;
*)
echo "Usage: $0 { start | stop }"
;;
esac
exit 0