473,555 Members | 2,322 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

postgres on SuSE 9.1

Dear my friends...

Usually I use MySQL. Now I have to migrate my database
from MySQL to Postgres.

I have created a database successfully with "creatdb"
and a user account successfully.

But I can not access the postgres with pgaccess.

I found this error message :
"
Error trying to connect to database 'custadm' on host
localhost

PostgreSQL error message: Connection to database
failed
could not create socket: ©Hÿ¿pHÿ¿lH ÿ¿
"
Error in startup script: window ".pgaw:Open DB" was
deleted before its visibility changed
while executing
"tkwait visibility .pgaw:OpenDB"
(procedure "::Connections: :openConn" line 40)
invoked from within
"::Connections: :openConn $i 1"
(procedure "main" line 63)
invoked from within
"main $argc $argv"
(file "/usr/bin/pgaccess" line 810)
patrixlinux@pat rix:~>
"

Here what I have done
"
patrixlinux@pat rix:~> su
Password:
patrix:/localhome/patrixlinux # su postgres
postgres@patrix :/localhome/patrixlinux> cd
postgres@patrix :~> psql custadm
Welcome to psql 7.4.2, the PostgreSQL interactive
terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

custadm=# create user someone with password 'pass_me'
createdb;
CREATE USER
custadm=#
"

Anybody would be so nice to tell me why I can not
access my postgres with pgaccess?

Thank you very much in advance.


_______________ _______________ ____
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #1
6 2932
Prabu Subroto <pr***********@ yahoo.com> wrote:
Dear my friends...

Usually I use MySQL. Now I have to migrate my database
from MySQL to Postgres.

I have created a database successfully with "creatdb"
and a user account successfully.

But I can not access the postgres with pgaccess.

I found this error message :
"
Error trying to connect to database 'custadm' on host
localhost

PostgreSQL error message: Connection to database
failed
could not create socket: __H____pH____lH ____
"
Error in startup script: window ".pgaw:Open DB" was
deleted before its visibility changed
while executing
"tkwait visibility .pgaw:OpenDB"
(procedure "::Connections: :openConn" line 40)
invoked from within
"::Connections: :openConn $i 1"
(procedure "main" line 63)
invoked from within
"main $argc $argv"
(file "/usr/bin/pgaccess" line 810)
patrixlinux@pat rix:~>
"

Here what I have done
"
patrixlinux@pat rix:~> su
Password:
patrix:/localhome/patrixlinux # su postgres
postgres@patrix :/localhome/patrixlinux> cd
postgres@patrix :~> psql custadm
Welcome to psql 7.4.2, the PostgreSQL interactive
terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

custadm=# create user someone with password 'pass_me'
createdb;
CREATE USER
custadm=#
"

Anybody would be so nice to tell me why I can not
access my postgres with pgaccess?

Thank you very much in advance.


I would guess that Posgres is not listening on an IPv4 socket. I think pgaccess
always connects via an IPv4 socket. (may be wrong here ...)

Anyway, check your postgresql.conf file to see if the option to listen on a
tcp/ip port is turned on. If not, that's almost definately your problem.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2
Prabu Subroto <pr***********@ yahoo.com> wrote:
Dear my friends...

Usually I use MySQL. Now I have to migrate my database
from MySQL to Postgres.

I have created a database successfully with "creatdb"
and a user account successfully.

But I can not access the postgres with pgaccess.

I found this error message :
"
Error trying to connect to database 'custadm' on host
localhost

PostgreSQL error message: Connection to database
failed
could not create socket: __H____pH____lH ____
"
Error in startup script: window ".pgaw:Open DB" was
deleted before its visibility changed
while executing
"tkwait visibility .pgaw:OpenDB"
(procedure "::Connections: :openConn" line 40)
invoked from within
"::Connections: :openConn $i 1"
(procedure "main" line 63)
invoked from within
"main $argc $argv"
(file "/usr/bin/pgaccess" line 810)
patrixlinux@pat rix:~>
"

Here what I have done
"
patrixlinux@pat rix:~> su
Password:
patrix:/localhome/patrixlinux # su postgres
postgres@patrix :/localhome/patrixlinux> cd
postgres@patrix :~> psql custadm
Welcome to psql 7.4.2, the PostgreSQL interactive
terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

custadm=# create user someone with password 'pass_me'
createdb;
CREATE USER
custadm=#
"

Anybody would be so nice to tell me why I can not
access my postgres with pgaccess?

Thank you very much in advance.


I would guess that Posgres is not listening on an IPv4 socket. I think pgaccess
always connects via an IPv4 socket. (may be wrong here ...)

Anyway, check your postgresql.conf file to see if the option to listen on a
tcp/ip port is turned on. If not, that's almost definately your problem.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #3
Dear Bill

I tried to modify my postgresql.conf file. But
lookslike it is not correct yet.

Please tell me where the mistake.

Here I attached my postgresql.conf .

TIA.

patrix:/var/lib/pgsql/data # ls
.. .. PG_VERSION base global pg_clog pg_hba.conf
pg_ident.conf pg_xlog postgresql.conf
postmaster.opts
patrix:/var/lib/pgsql/data # vi postgresql.conf
patrix:/var/lib/pgsql/data # cat postgresql.conf
# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
# name = value
#
# (The '=' is optional.) White space may be used.
Comments are introduced
# with '#' anywhere on a line. The complete list of
option names and
# allowed values can be found in the PostgreSQL
documentation. The
# commented-out settings shown in this file represent
the default values.
#
# Any option can also be given as a command line
switch to the
# postmaster, e.g. 'postmaster -c log_connections =on'.
Some options
# can be changed at run-time with the 'SET' SQL
command.
#
# This file is read on postmaster startup and when the
postmaster
# receives a SIGHUP. If you edit the file on a running
system, you have
# to SIGHUP the postmaster for the changes to take
effect, or use
# "pg_ctl reload".
#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------

# - Connection Settings -

tcpip_socket = true
max_connections = 100
# note: increasing max_connections costs about
500 bytes of shared
# memory per connection slot, in addition to
costs from shared_buffers
# and max_locks_per_t ransaction.
superuser_reser ved_connections = 2
port = 5432
unix_socket_dir ectory = ''
unix_socket_gro up = ''
unix_socket_per missions = 0777 # octal
virtual_host = '192.168.23.237 ' # what
interface to listen on; defaults to any
rendezvous_name = '' # defaults to the
computer name

# - Security & Authentication -

authentication_ timeout = 60 # 1-600, in seconds
ssl = true
password_encryp tion = true
krb_server_keyf ile = ''
db_user_namespa ce = false
#---------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#---------------------------------------------------------------------------

# - Memory -

shared_buffers = 1000 # min 16, at least
max_connections *2, 8KB each
#sort_mem = 1024 # min 64, size in KB
#vacuum_mem = 8192 # min 1024, size in KB

# - Free Space Map -

#max_fsm_pages = 20000 # min
max_fsm_relatio ns*16, 6 bytes each
#max_fsm_relati ons = 1000 # min 100, ~50 bytes
each

# - Kernel Resource Usage -

#max_files_per_ process = 1000 # min 25
#preload_librar ies = ''
#---------------------------------------------------------------------------
# WRITE AHEAD LOG
#---------------------------------------------------------------------------

# - Settings -

#fsync = true # turns forced
synchronization on or off
#wal_sync_metho d = fsync # the default varies
across platforms:
# fsync, fdatasync,
open_sync, or open_datasync
#wal_buffers = 8 # min 4, 8KB each

# - Checkpoints -

#checkpoint_seg ments = 3 # in logfile segments,
min 1, 16MB each
#checkpoint_tim eout = 300 # range 30-3600, in
seconds
#checkpoint_war ning = 30 # 0 is off, in seconds
#commit_delay = 0 # range 0-100000, in
microseconds
#commit_sibling s = 5 # range 1-1000
#---------------------------------------------------------------------------
# QUERY TUNING
#---------------------------------------------------------------------------

# - Planner Method Enabling -

#enable_hashagg = true
#enable_hashjoi n = true
#enable_indexsc an = true
#enable_mergejo in = true
#enable_nestloo p = true
#enable_seqscan = true
#enable_sort = true
#enable_tidscan = true

# - Planner Cost Constants -

#effective_cach e_size = 1000 # typically 8KB each
#random_page_co st = 4 # units are one
sequential page fetch cost
#cpu_tuple_cost = 0.01 # (same)
#cpu_index_tupl e_cost = 0.001 # (same)
#cpu_operator_c ost = 0.0025 # (same)

# - Genetic Query Optimizer -

#geqo = true
#geqo_threshold = 11
#geqo_effort = 1
#geqo_generatio ns = 0
#geqo_pool_size = 0 # default based on
tables in statement,
# range 128-1024
#geqo_selection _bias = 2.0 # range 1.5-2.0

# - Other Planner Options -

#default_statis tics_target = 10 # range 1-1000
#from_collapse_ limit = 8
#join_collapse_ limit = 8 # 1 disables
collapsing of explicit JOINs
#---------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#---------------------------------------------------------------------------

# - Syslog -

#syslog = 0 # range 0-2; 0=stdout;
1=both; 2=syslog
#syslog_facilit y = 'LOCAL0'
#syslog_ident = 'postgres'

# - When to Log -

#client_min_mes sages = notice # Values, in order of
decreasing detail:
# debug5, debug4,
debug3, debug2, debug1,
# log, info, notice,
warning, error

#log_min_messag es = notice # Values, in order of
decreasing detail:
# debug5, debug4,
debug3, debug2, debug1,
# info, notice,
warning, error, log, fatal,
# panic

#log_error_verb osity = default # terse, default, or
verbose messages

#log_min_error_ statement = panic # Values in order of
increasing severity:
# debug5, debug4,
debug3, debug2, debug1,
# info, notice,
warning, error, panic(off)

#log_min_durati on_statement = -1 # Log all statements
whose
# execution time
exceeds the value, in
# milliseconds. Zero
prints all queries.
# Minus-one disables.

#silent_mode = false # DO NOT USE without
Syslog!

# - What to Log -

#debug_print_pa rse = false
#debug_print_re written = false
#debug_print_pl an = false
#debug_pretty_p rint = false
#log_connection s = false
#log_duration = false
#log_pid = false
#log_statement = false
log_timestamp = true
#log_hostname = false
#log_source_por t = false
#---------------------------------------------------------------------------
# RUNTIME STATISTICS
#---------------------------------------------------------------------------

# - Statistics Monitoring -

#log_parser_sta ts = false
#log_planner_st ats = false
#log_executor_s tats = false
#log_statement_ stats = false

# - Query/Index Statistics Collector -

#stats_start_co llector = true
#stats_command_ string = false
#stats_block_le vel = false
#stats_row_leve l = false
#stats_reset_on _server_start = true
#---------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#---------------------------------------------------------------------------

# - Statement Behavior -

#search_path = '$user,public' # schema names
#check_function _bodies = true
#default_transa ction_isolation = 'read committed'
#default_transa ction_read_only = false
#statement_time out = 0 # 0 is disabled, in
milliseconds

# - Locale and Formatting -

#datestyle = 'iso, mdy'
#timezone = unknown # actually, defaults
to TZ environment setting
#australian_tim ezones = false
#extra_float_di gits = 0 # min -15, max 2
#client_encodin g = sql_ascii # actually, defaults
to database encoding

# These settings are initialized by initdb -- they may
be changed
lc_messages = 'en_US.UTF-8' # locale for
system error message strings
lc_monetary = 'en_US.UTF-8' # locale for
monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for
number formatting
lc_time = 'en_US.UTF-8' # locale for
time formatting

# - Other Defaults -

#explain_pretty _print = true
#dynamic_librar y_path = '$libdir'
#max_expr_depth = 10000 # min 10
#---------------------------------------------------------------------------
# LOCK MANAGEMENT
#---------------------------------------------------------------------------

#deadlock_timeo ut = 1000 # in milliseconds
#max_locks_per_ transaction = 64 # min 10,
~260*max_connec tions bytes each
#---------------------------------------------------------------------------
# VERSION/PLATFORM COMPATIBILITY
#---------------------------------------------------------------------------

# - Previous Postgres Versions -

#add_missing_fr om = true
#regex_flavor = advanced # advanced, extended,
or basic
#sql_inheritanc e = true

# - Other Platforms & Clients -

#transform_null _equals = false
patrix:/var/lib/pgsql/data #
--- Bill Moran <wm****@potenti altech.com> wrote:
Prabu Subroto <pr***********@ yahoo.com> wrote:
Dear my friends...

Usually I use MySQL. Now I have to migrate my

database
from MySQL to Postgres.

I have created a database successfully with

"creatdb"
and a user account successfully.

But I can not access the postgres with pgaccess.

I found this error message :
"
Error trying to connect to database 'custadm' on

host
localhost

PostgreSQL error message: Connection to database
failed
could not create socket: __H____pH____lH ____
"
Error in startup script: window ".pgaw:Open DB" was
deleted before its visibility changed
while executing
"tkwait visibility .pgaw:OpenDB"
(procedure "::Connections: :openConn" line 40)
invoked from within
"::Connections: :openConn $i 1"
(procedure "main" line 63)
invoked from within
"main $argc $argv"
(file "/usr/bin/pgaccess" line 810)
patrixlinux@pat rix:~>
"

Here what I have done
"
patrixlinux@pat rix:~> su
Password:
patrix:/localhome/patrixlinux # su postgres
postgres@patrix :/localhome/patrixlinux> cd
postgres@patrix :~> psql custadm
Welcome to psql 7.4.2, the PostgreSQL interactive
terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute

query
\q to quit

custadm=# create user someone with password

'pass_me'
createdb;
CREATE USER
custadm=#
"

Anybody would be so nice to tell me why I can not
access my postgres with pgaccess?

Thank you very much in advance.


I would guess that Posgres is not listening on an
IPv4 socket. I think pgaccess
always connects via an IPv4 socket. (may be wrong
here ...)

Anyway, check your postgresql.conf file to see if
the option to listen on a
tcp/ip port is turned on. If not, that's almost
definately your problem.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com

---------------------------(end of
broadcast)---------------------------
TIP 7: don't forget to increase your free space map

settings

_______________ _______________ ____
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #4
Dear Bill

I tried to modify my postgresql.conf file. But
lookslike it is not correct yet.

Please tell me where the mistake.

Here I attached my postgresql.conf .

TIA.

patrix:/var/lib/pgsql/data # ls
.. .. PG_VERSION base global pg_clog pg_hba.conf
pg_ident.conf pg_xlog postgresql.conf
postmaster.opts
patrix:/var/lib/pgsql/data # vi postgresql.conf
patrix:/var/lib/pgsql/data # cat postgresql.conf
# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
# name = value
#
# (The '=' is optional.) White space may be used.
Comments are introduced
# with '#' anywhere on a line. The complete list of
option names and
# allowed values can be found in the PostgreSQL
documentation. The
# commented-out settings shown in this file represent
the default values.
#
# Any option can also be given as a command line
switch to the
# postmaster, e.g. 'postmaster -c log_connections =on'.
Some options
# can be changed at run-time with the 'SET' SQL
command.
#
# This file is read on postmaster startup and when the
postmaster
# receives a SIGHUP. If you edit the file on a running
system, you have
# to SIGHUP the postmaster for the changes to take
effect, or use
# "pg_ctl reload".
#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------

# - Connection Settings -

tcpip_socket = true
max_connections = 100
# note: increasing max_connections costs about
500 bytes of shared
# memory per connection slot, in addition to
costs from shared_buffers
# and max_locks_per_t ransaction.
superuser_reser ved_connections = 2
port = 5432
unix_socket_dir ectory = ''
unix_socket_gro up = ''
unix_socket_per missions = 0777 # octal
virtual_host = '192.168.23.237 ' # what
interface to listen on; defaults to any
rendezvous_name = '' # defaults to the
computer name

# - Security & Authentication -

authentication_ timeout = 60 # 1-600, in seconds
ssl = true
password_encryp tion = true
krb_server_keyf ile = ''
db_user_namespa ce = false
#---------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#---------------------------------------------------------------------------

# - Memory -

shared_buffers = 1000 # min 16, at least
max_connections *2, 8KB each
#sort_mem = 1024 # min 64, size in KB
#vacuum_mem = 8192 # min 1024, size in KB

# - Free Space Map -

#max_fsm_pages = 20000 # min
max_fsm_relatio ns*16, 6 bytes each
#max_fsm_relati ons = 1000 # min 100, ~50 bytes
each

# - Kernel Resource Usage -

#max_files_per_ process = 1000 # min 25
#preload_librar ies = ''
#---------------------------------------------------------------------------
# WRITE AHEAD LOG
#---------------------------------------------------------------------------

# - Settings -

#fsync = true # turns forced
synchronization on or off
#wal_sync_metho d = fsync # the default varies
across platforms:
# fsync, fdatasync,
open_sync, or open_datasync
#wal_buffers = 8 # min 4, 8KB each

# - Checkpoints -

#checkpoint_seg ments = 3 # in logfile segments,
min 1, 16MB each
#checkpoint_tim eout = 300 # range 30-3600, in
seconds
#checkpoint_war ning = 30 # 0 is off, in seconds
#commit_delay = 0 # range 0-100000, in
microseconds
#commit_sibling s = 5 # range 1-1000
#---------------------------------------------------------------------------
# QUERY TUNING
#---------------------------------------------------------------------------

# - Planner Method Enabling -

#enable_hashagg = true
#enable_hashjoi n = true
#enable_indexsc an = true
#enable_mergejo in = true
#enable_nestloo p = true
#enable_seqscan = true
#enable_sort = true
#enable_tidscan = true

# - Planner Cost Constants -

#effective_cach e_size = 1000 # typically 8KB each
#random_page_co st = 4 # units are one
sequential page fetch cost
#cpu_tuple_cost = 0.01 # (same)
#cpu_index_tupl e_cost = 0.001 # (same)
#cpu_operator_c ost = 0.0025 # (same)

# - Genetic Query Optimizer -

#geqo = true
#geqo_threshold = 11
#geqo_effort = 1
#geqo_generatio ns = 0
#geqo_pool_size = 0 # default based on
tables in statement,
# range 128-1024
#geqo_selection _bias = 2.0 # range 1.5-2.0

# - Other Planner Options -

#default_statis tics_target = 10 # range 1-1000
#from_collapse_ limit = 8
#join_collapse_ limit = 8 # 1 disables
collapsing of explicit JOINs
#---------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#---------------------------------------------------------------------------

# - Syslog -

#syslog = 0 # range 0-2; 0=stdout;
1=both; 2=syslog
#syslog_facilit y = 'LOCAL0'
#syslog_ident = 'postgres'

# - When to Log -

#client_min_mes sages = notice # Values, in order of
decreasing detail:
# debug5, debug4,
debug3, debug2, debug1,
# log, info, notice,
warning, error

#log_min_messag es = notice # Values, in order of
decreasing detail:
# debug5, debug4,
debug3, debug2, debug1,
# info, notice,
warning, error, log, fatal,
# panic

#log_error_verb osity = default # terse, default, or
verbose messages

#log_min_error_ statement = panic # Values in order of
increasing severity:
# debug5, debug4,
debug3, debug2, debug1,
# info, notice,
warning, error, panic(off)

#log_min_durati on_statement = -1 # Log all statements
whose
# execution time
exceeds the value, in
# milliseconds. Zero
prints all queries.
# Minus-one disables.

#silent_mode = false # DO NOT USE without
Syslog!

# - What to Log -

#debug_print_pa rse = false
#debug_print_re written = false
#debug_print_pl an = false
#debug_pretty_p rint = false
#log_connection s = false
#log_duration = false
#log_pid = false
#log_statement = false
log_timestamp = true
#log_hostname = false
#log_source_por t = false
#---------------------------------------------------------------------------
# RUNTIME STATISTICS
#---------------------------------------------------------------------------

# - Statistics Monitoring -

#log_parser_sta ts = false
#log_planner_st ats = false
#log_executor_s tats = false
#log_statement_ stats = false

# - Query/Index Statistics Collector -

#stats_start_co llector = true
#stats_command_ string = false
#stats_block_le vel = false
#stats_row_leve l = false
#stats_reset_on _server_start = true
#---------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#---------------------------------------------------------------------------

# - Statement Behavior -

#search_path = '$user,public' # schema names
#check_function _bodies = true
#default_transa ction_isolation = 'read committed'
#default_transa ction_read_only = false
#statement_time out = 0 # 0 is disabled, in
milliseconds

# - Locale and Formatting -

#datestyle = 'iso, mdy'
#timezone = unknown # actually, defaults
to TZ environment setting
#australian_tim ezones = false
#extra_float_di gits = 0 # min -15, max 2
#client_encodin g = sql_ascii # actually, defaults
to database encoding

# These settings are initialized by initdb -- they may
be changed
lc_messages = 'en_US.UTF-8' # locale for
system error message strings
lc_monetary = 'en_US.UTF-8' # locale for
monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for
number formatting
lc_time = 'en_US.UTF-8' # locale for
time formatting

# - Other Defaults -

#explain_pretty _print = true
#dynamic_librar y_path = '$libdir'
#max_expr_depth = 10000 # min 10
#---------------------------------------------------------------------------
# LOCK MANAGEMENT
#---------------------------------------------------------------------------

#deadlock_timeo ut = 1000 # in milliseconds
#max_locks_per_ transaction = 64 # min 10,
~260*max_connec tions bytes each
#---------------------------------------------------------------------------
# VERSION/PLATFORM COMPATIBILITY
#---------------------------------------------------------------------------

# - Previous Postgres Versions -

#add_missing_fr om = true
#regex_flavor = advanced # advanced, extended,
or basic
#sql_inheritanc e = true

# - Other Platforms & Clients -

#transform_null _equals = false
patrix:/var/lib/pgsql/data #
--- Bill Moran <wm****@potenti altech.com> wrote:
Prabu Subroto <pr***********@ yahoo.com> wrote:
Dear my friends...

Usually I use MySQL. Now I have to migrate my

database
from MySQL to Postgres.

I have created a database successfully with

"creatdb"
and a user account successfully.

But I can not access the postgres with pgaccess.

I found this error message :
"
Error trying to connect to database 'custadm' on

host
localhost

PostgreSQL error message: Connection to database
failed
could not create socket: __H____pH____lH ____
"
Error in startup script: window ".pgaw:Open DB" was
deleted before its visibility changed
while executing
"tkwait visibility .pgaw:OpenDB"
(procedure "::Connections: :openConn" line 40)
invoked from within
"::Connections: :openConn $i 1"
(procedure "main" line 63)
invoked from within
"main $argc $argv"
(file "/usr/bin/pgaccess" line 810)
patrixlinux@pat rix:~>
"

Here what I have done
"
patrixlinux@pat rix:~> su
Password:
patrix:/localhome/patrixlinux # su postgres
postgres@patrix :/localhome/patrixlinux> cd
postgres@patrix :~> psql custadm
Welcome to psql 7.4.2, the PostgreSQL interactive
terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute

query
\q to quit

custadm=# create user someone with password

'pass_me'
createdb;
CREATE USER
custadm=#
"

Anybody would be so nice to tell me why I can not
access my postgres with pgaccess?

Thank you very much in advance.


I would guess that Posgres is not listening on an
IPv4 socket. I think pgaccess
always connects via an IPv4 socket. (may be wrong
here ...)

Anyway, check your postgresql.conf file to see if
the option to listen on a
tcp/ip port is turned on. If not, that's almost
definately your problem.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com

---------------------------(end of
broadcast)---------------------------
TIP 7: don't forget to increase your free space map

settings

_______________ _______________ ____
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #5
Prabu,

You need to allow Postgres to accept TCP/IP connections.
There are two ways to do that in SuSE :

1. run yast2, go to "System", click on "/etc/sysconfig Editor",
go to Applications/PostgreSQL/POSTGRES_OPTION S
and add -i parameter, click on Finish ... SuSE will do all the rest.
2. edit file /var/lib/pgsql/data/postgresql.conf and set
tcp_socket to true. You need to restart postgres after that:
/etc/init.d/postgresql restart

Regards,
Mikhail
Prabu Subroto wrote:
Dear my friends...

Usually I use MySQL. Now I have to migrate my database
from MySQL to Postgres.

I have created a database successfully with "creatdb"
and a user account successfully.

But I can not access the postgres with pgaccess.

I found this error message :
"
Error trying to connect to database 'custadm' on host
localhost

PostgreSQL error message: Connection to database
failed
could not create socket: ©Hÿ¿pHÿ¿lH ÿ¿
"
Error in startup script: window ".pgaw:Open DB" was
deleted before its visibility changed
while executing
"tkwait visibility .pgaw:OpenDB"
(procedure "::Connections: :openConn" line 40)
invoked from within
"::Connections ::openConn $i 1"
(procedure "main" line 63)
invoked from within
"main $argc $argv"
(file "/usr/bin/pgaccess" line 810)
patrixlinux@pa trix:~>
"

Here what I have done
"
patrixlinux@pa trix:~> su
Password:
patrix:/localhome/patrixlinux # su postgres
postgres@patri x:/localhome/patrixlinux> cd
postgres@patri x:~> psql custadm
Welcome to psql 7.4.2, the PostgreSQL interactive
terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

custadm=# create user someone with password 'pass_me'
createdb;
CREATE USER
custadm=#
"

Anybody would be so nice to tell me why I can not
access my postgres with pgaccess?

Thank you very much in advance.


______________ _______________ _____
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #6
Prabu,

You need to allow Postgres to accept TCP/IP connections.
There are two ways to do that in SuSE :

1. run yast2, go to "System", click on "/etc/sysconfig Editor",
go to Applications/PostgreSQL/POSTGRES_OPTION S
and add -i parameter, click on Finish ... SuSE will do all the rest.
2. edit file /var/lib/pgsql/data/postgresql.conf and set
tcp_socket to true. You need to restart postgres after that:
/etc/init.d/postgresql restart

Regards,
Mikhail
Prabu Subroto wrote:
Dear my friends...

Usually I use MySQL. Now I have to migrate my database
from MySQL to Postgres.

I have created a database successfully with "creatdb"
and a user account successfully.

But I can not access the postgres with pgaccess.

I found this error message :
"
Error trying to connect to database 'custadm' on host
localhost

PostgreSQL error message: Connection to database
failed
could not create socket: ©Hÿ¿pHÿ¿lH ÿ¿
"
Error in startup script: window ".pgaw:Open DB" was
deleted before its visibility changed
while executing
"tkwait visibility .pgaw:OpenDB"
(procedure "::Connections: :openConn" line 40)
invoked from within
"::Connections ::openConn $i 1"
(procedure "main" line 63)
invoked from within
"main $argc $argv"
(file "/usr/bin/pgaccess" line 810)
patrixlinux@pa trix:~>
"

Here what I have done
"
patrixlinux@pa trix:~> su
Password:
patrix:/localhome/patrixlinux # su postgres
postgres@patri x:/localhome/patrixlinux> cd
postgres@patri x:~> psql custadm
Welcome to psql 7.4.2, the PostgreSQL interactive
terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

custadm=# create user someone with password 'pass_me'
createdb;
CREATE USER
custadm=#
"

Anybody would be so nice to tell me why I can not
access my postgres with pgaccess?

Thank you very much in advance.


______________ _______________ _____
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1017
by: Sharath Kumar | last post by:
hi. pls help me in installing postgres 7.3.0 rpm for suse linux 8.0. reg sharath ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your
4
2834
by: Gellert, Andre | last post by:
Hello, we installed a new Postgres 7.4.0 on a Suse 9 system. This is used as a part of an extranet , based on Apache+PHP and has besides a ldap server no services running. The system has dual xeon 2ghz and 2GB RAM. When migrating all applications from 2 other postgres7.2 servers to the new one, we had heavy load problems. At the beginning...
2
1896
by: Gellert, Andre | last post by:
Hi everybody, currenty we use Suse Linux 9 and the rpms with 7.4.0 downloaded from ftp://ftp.gmd.de/mirrors2/suse/ftp.suse.com/people/max/postgresql-7.4/ . I don't know how to contact the person who build this rpms , and i cannot find other resources on the web, so does anyone know a place to get Postgres 7.4.1 RPMs for SuSE 9.0 ? ...
0
337
by: Prabu Subroto | last post by:
Dear my friends... Usually I use MySQL. Now I have to migrate my database from MySQL to Postgres. I have created a database successfully with "creatdb" and a user account successfully. But I can not access the postgres with pgaccess.
2
1272
by: Prabu Subroto | last post by:
Dear my friends... I am planning to migrate my database from MySQL to Postgres since the MySQL does not have subquery except it 4.1. And I can not wait until the 4.1 stable version released and included in SuSE distro. I did mysqldump (into a file, basisdata.txt) and I am going to do its query qith pgaccess or pgsql.
5
2355
by: Prabu Subroto | last post by:
Dear my friends... I am using SuSE Linux 9.1 and postgres. I am a beginner in postgres, usually I use MySQL. I have 3 tables : appointment, appointment0 and appointment1. the fields of table "appointment" are as follows: noapp* (int4):ID Number of appointment (PK)
18
5110
by: Joe Lester | last post by:
This thread was renamed. It used to be: "shared_buffers Question". The old thread kind of died out. I'm hoping to get some more direction by rephrasing the problem, along with some extra observations I've recently made. The core of the problem is that Postgres is filling up my hard drive with swap files at the rate of around 3 to 7 GB per...
1
1649
by: Claudia Restrepo Pajon - Practicante Sistemas | last post by:
suscribe hola! Yo soy Claudia M Restrepo P. Me encuentro realizando mi practica empresarial (estudiante de ingenieria de sistemas)y ya monte en un servidor proliant, procesador pentium 3 DIM 128M, disco duro IDE 20GB. En el cual instale Linux Suse 9.1, estoy trabjando en la base de datos Postgres obviamente he investigado mucho tanto via...
0
2157
by: fchen00 | last post by:
Hi there, Im running Postgres on SuSe Linux and some times the database uses so much disk space that we got disk full problems. Is there a way in postgres to specify how much disk space to use? For instance, Id like it to use no more than 50G. And if there is such parameter, what is the effect? Will postgres simply stop writing to the disk?...
0
7542
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8060
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7587
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7903
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6176
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5170
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3593
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3573
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1156
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.