473,287 Members | 1,560 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

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:OpenDB" 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@patrix:~>
"

Here what I have done
"
patrixlinux@patrix:~> 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 2912
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:OpenDB" 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@patrix:~>
"

Here what I have done
"
patrixlinux@patrix:~> 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:OpenDB" 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@patrix:~>
"

Here what I have done
"
patrixlinux@patrix:~> 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_transaction.
superuser_reserved_connections = 2
port = 5432
unix_socket_directory = ''
unix_socket_group = ''
unix_socket_permissions = 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_encryption = true
krb_server_keyfile = ''
db_user_namespace = 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_relations*16, 6 bytes each
#max_fsm_relations = 1000 # min 100, ~50 bytes
each

# - Kernel Resource Usage -

#max_files_per_process = 1000 # min 25
#preload_libraries = ''
#---------------------------------------------------------------------------
# WRITE AHEAD LOG
#---------------------------------------------------------------------------

# - Settings -

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

# - Checkpoints -

#checkpoint_segments = 3 # in logfile segments,
min 1, 16MB each
#checkpoint_timeout = 300 # range 30-3600, in
seconds
#checkpoint_warning = 30 # 0 is off, in seconds
#commit_delay = 0 # range 0-100000, in
microseconds
#commit_siblings = 5 # range 1-1000
#---------------------------------------------------------------------------
# QUERY TUNING
#---------------------------------------------------------------------------

# - Planner Method Enabling -

#enable_hashagg = true
#enable_hashjoin = true
#enable_indexscan = true
#enable_mergejoin = true
#enable_nestloop = true
#enable_seqscan = true
#enable_sort = true
#enable_tidscan = true

# - Planner Cost Constants -

#effective_cache_size = 1000 # typically 8KB each
#random_page_cost = 4 # units are one
sequential page fetch cost
#cpu_tuple_cost = 0.01 # (same)
#cpu_index_tuple_cost = 0.001 # (same)
#cpu_operator_cost = 0.0025 # (same)

# - Genetic Query Optimizer -

#geqo = true
#geqo_threshold = 11
#geqo_effort = 1
#geqo_generations = 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_statistics_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_facility = 'LOCAL0'
#syslog_ident = 'postgres'

# - When to Log -

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

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

#log_error_verbosity = 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_duration_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_parse = false
#debug_print_rewritten = false
#debug_print_plan = false
#debug_pretty_print = false
#log_connections = false
#log_duration = false
#log_pid = false
#log_statement = false
log_timestamp = true
#log_hostname = false
#log_source_port = false
#---------------------------------------------------------------------------
# RUNTIME STATISTICS
#---------------------------------------------------------------------------

# - Statistics Monitoring -

#log_parser_stats = false
#log_planner_stats = false
#log_executor_stats = false
#log_statement_stats = false

# - Query/Index Statistics Collector -

#stats_start_collector = true
#stats_command_string = false
#stats_block_level = false
#stats_row_level = false
#stats_reset_on_server_start = true
#---------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#---------------------------------------------------------------------------

# - Statement Behavior -

#search_path = '$user,public' # schema names
#check_function_bodies = true
#default_transaction_isolation = 'read committed'
#default_transaction_read_only = false
#statement_timeout = 0 # 0 is disabled, in
milliseconds

# - Locale and Formatting -

#datestyle = 'iso, mdy'
#timezone = unknown # actually, defaults
to TZ environment setting
#australian_timezones = false
#extra_float_digits = 0 # min -15, max 2
#client_encoding = 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_library_path = '$libdir'
#max_expr_depth = 10000 # min 10
#---------------------------------------------------------------------------
# LOCK MANAGEMENT
#---------------------------------------------------------------------------

#deadlock_timeout = 1000 # in milliseconds
#max_locks_per_transaction = 64 # min 10,
~260*max_connections bytes each
#---------------------------------------------------------------------------
# VERSION/PLATFORM COMPATIBILITY
#---------------------------------------------------------------------------

# - Previous Postgres Versions -

#add_missing_from = true
#regex_flavor = advanced # advanced, extended,
or basic
#sql_inheritance = true

# - Other Platforms & Clients -

#transform_null_equals = false
patrix:/var/lib/pgsql/data #
--- Bill Moran <wm****@potentialtech.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:OpenDB" 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@patrix:~>
"

Here what I have done
"
patrixlinux@patrix:~> 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_transaction.
superuser_reserved_connections = 2
port = 5432
unix_socket_directory = ''
unix_socket_group = ''
unix_socket_permissions = 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_encryption = true
krb_server_keyfile = ''
db_user_namespace = 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_relations*16, 6 bytes each
#max_fsm_relations = 1000 # min 100, ~50 bytes
each

# - Kernel Resource Usage -

#max_files_per_process = 1000 # min 25
#preload_libraries = ''
#---------------------------------------------------------------------------
# WRITE AHEAD LOG
#---------------------------------------------------------------------------

# - Settings -

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

# - Checkpoints -

#checkpoint_segments = 3 # in logfile segments,
min 1, 16MB each
#checkpoint_timeout = 300 # range 30-3600, in
seconds
#checkpoint_warning = 30 # 0 is off, in seconds
#commit_delay = 0 # range 0-100000, in
microseconds
#commit_siblings = 5 # range 1-1000
#---------------------------------------------------------------------------
# QUERY TUNING
#---------------------------------------------------------------------------

# - Planner Method Enabling -

#enable_hashagg = true
#enable_hashjoin = true
#enable_indexscan = true
#enable_mergejoin = true
#enable_nestloop = true
#enable_seqscan = true
#enable_sort = true
#enable_tidscan = true

# - Planner Cost Constants -

#effective_cache_size = 1000 # typically 8KB each
#random_page_cost = 4 # units are one
sequential page fetch cost
#cpu_tuple_cost = 0.01 # (same)
#cpu_index_tuple_cost = 0.001 # (same)
#cpu_operator_cost = 0.0025 # (same)

# - Genetic Query Optimizer -

#geqo = true
#geqo_threshold = 11
#geqo_effort = 1
#geqo_generations = 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_statistics_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_facility = 'LOCAL0'
#syslog_ident = 'postgres'

# - When to Log -

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

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

#log_error_verbosity = 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_duration_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_parse = false
#debug_print_rewritten = false
#debug_print_plan = false
#debug_pretty_print = false
#log_connections = false
#log_duration = false
#log_pid = false
#log_statement = false
log_timestamp = true
#log_hostname = false
#log_source_port = false
#---------------------------------------------------------------------------
# RUNTIME STATISTICS
#---------------------------------------------------------------------------

# - Statistics Monitoring -

#log_parser_stats = false
#log_planner_stats = false
#log_executor_stats = false
#log_statement_stats = false

# - Query/Index Statistics Collector -

#stats_start_collector = true
#stats_command_string = false
#stats_block_level = false
#stats_row_level = false
#stats_reset_on_server_start = true
#---------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#---------------------------------------------------------------------------

# - Statement Behavior -

#search_path = '$user,public' # schema names
#check_function_bodies = true
#default_transaction_isolation = 'read committed'
#default_transaction_read_only = false
#statement_timeout = 0 # 0 is disabled, in
milliseconds

# - Locale and Formatting -

#datestyle = 'iso, mdy'
#timezone = unknown # actually, defaults
to TZ environment setting
#australian_timezones = false
#extra_float_digits = 0 # min -15, max 2
#client_encoding = 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_library_path = '$libdir'
#max_expr_depth = 10000 # min 10
#---------------------------------------------------------------------------
# LOCK MANAGEMENT
#---------------------------------------------------------------------------

#deadlock_timeout = 1000 # in milliseconds
#max_locks_per_transaction = 64 # min 10,
~260*max_connections bytes each
#---------------------------------------------------------------------------
# VERSION/PLATFORM COMPATIBILITY
#---------------------------------------------------------------------------

# - Previous Postgres Versions -

#add_missing_from = true
#regex_flavor = advanced # advanced, extended,
or basic
#sql_inheritance = true

# - Other Platforms & Clients -

#transform_null_equals = false
patrix:/var/lib/pgsql/data #
--- Bill Moran <wm****@potentialtech.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:OpenDB" 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@patrix:~>
"

Here what I have done
"
patrixlinux@patrix:~> 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_OPTIONS
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:OpenDB" 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@patrix:~>
"

Here what I have done
"
patrixlinux@patrix:~> 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

---------------------------(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_OPTIONS
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:OpenDB" 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@patrix:~>
"

Here what I have done
"
patrixlinux@patrix:~> 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

---------------------------(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
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...
4
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...
2
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...
0
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...
2
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...
5
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...
18
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...
1
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...
0
by: fchen00 | last post by:
Hi there, I’m 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?...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

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.