cygwin on windows problem

"Beswick Alan" <[email protected]>
Newsgroups gmane.comp.db.postgresql.cygwin
Message-ID <29D325FBEE5C28428A31BA4E971C53CC015AB8A5@indpllymail.lands.resnet.qg>
Hi
I get the following errors trying to get postgres running. The system is
$ uname -a
CYGWIN_NT-5.1 nes10600 1.5.10(0.116/4/2) 2004-05-25 22:07 i686 unknown
unknown Cygwin

postgres is postgres (PostgreSQL) 7.4.3

postgres --describe-config output is attached
 <<postgres --describe-config.txt>> 

I also found this
$ grep 12 /usr/include/cygwin/signal.h
#define SIGSYS  12      /* bad argument to system call */

Any suggestions would be very gratefully received
ta
Alan



BESWICA@nes10600 ~
$ ipc-daemon2 &
[1] 3532

BESWICA@nes10600 ~
$ initdb -D /usr/local/pgsql/data -W -E LATIN1
The files belonging to this database system will be owned by user
"BESWICA".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
selecting default max_connections... Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
10
selecting default shared_buffers... Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
50
creating configuration files... ok
creating template1 database in /usr/local/pgsql/data/base/1... Signal 12

initdb: failed
initdb: removing data directory "/usr/local/pgsql/data"



Alan Beswick
Climate Impacts and Natural Resource Systems
Dept of Natural Resources, Mines and Energy
80 Meiers Rd, Indooroopilly 4068
Phone  	07 3896 9741
Facsimile 	07 3896 9843




************************************************************************
The information in this e-mail together with any attachments is
intended only for the person or entity to which it is addressed
and may contain confidential and/or privileged material.
Any form of review, disclosure, modification, distribution
and/or publication of this e-mail message is prohibited.  
If you have received this message in error, you are asked to
inform the sender as quickly as possible and delete this message
and any copies of this message from your computer and/or your
computer system network.  
************************************************************************


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match
postgresSettings.txt (text/plain, 18.5 KB)
add_missing_from	user	Version and Platform Compatibility / Previous PostgreSQL Versions	BOOLEAN	TRUE			Automatically adds missing table references to FROM clauses.	
australian_timezones	user	Client Connection Defaults / Locale and Formatting	BOOLEAN	FALSE			Interprets ACST, CST, EST, and SAT as Australian time zones.	Otherwise they are interpreted as North/South American time zones and Saturday.
authentication_timeout	sighup	Connections and Authentication / Security and Authentication	INTEGER	60	1	600	Sets the maximum time in seconds to complete client authentication.	
check_function_bodies	user	Client Connection Defaults / Statement Behavior	BOOLEAN	TRUE			Check function bodies during CREATE FUNCTION.	
checkpoint_segments	sighup	Write-Ahead Log / Checkpoints	INTEGER	3	1	2147483647	Sets the maximum distance in log segments between automatic WAL checkpoints.	
checkpoint_timeout	sighup	Write-Ahead Log / Checkpoints	INTEGER	300	30	3600	Sets the maximum time in seconds between automatic WAL checkpoints.	
checkpoint_warning	sighup	Write-Ahead Log / Checkpoints	INTEGER	30	0	2147483647	Logs if filling of checkpoint segments happens more frequently than this (in seconds).	Write a message to the server log if checkpoints caused by the filling of checkpoint segment files happens more frequently than this number of seconds. Zero turns off the warning.
client_encoding	user	Client Connection Defaults / Locale and Formatting	STRING	SQL_ASCII			Sets the client's character set encoding.	
client_min_messages	user	Reporting and Logging / When to Log	STRING	notice			Sets the message levels that are sent to the client.	Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, LOG, NOTICE, WARNING, and ERROR. Each level includes all the levels that follow it. The later the level, the fewer messages are sent.
commit_delay	user	Write-Ahead Log / Checkpoints	INTEGER	0	0	100000	Sets the delay in microseconds between transaction commit and flushing WAL to disk.	
commit_siblings	user	Write-Ahead Log / Checkpoints	INTEGER	5	1	1000	Sets the minimum concurrent open transactions before performing commit_delay.	
cpu_index_tuple_cost	user	Query Tuning / Planner Cost Constants	REAL	0.001	0	1.79769e+308	Sets the planner's estimate of processing cost for each index tuple (row) during index scan.	This is measured as a fraction of the cost of a sequential page fetch.
cpu_operator_cost	user	Query Tuning / Planner Cost Constants	REAL	0.0025	0	1.79769e+308	Sets the planner's estimate of processing cost of each operator in WHERE.	This is measured as a fraction of the cost of a sequential page fetch.
cpu_tuple_cost	user	Query Tuning / Planner Cost Constants	REAL	0.01	0	1.79769e+308	Sets the planner's estimate of the cost of processing each tuple (row).	This is measured as a fraction of the cost of a sequential page fetch.
DateStyle	user	Client Connection Defaults / Locale and Formatting	STRING	ISO, MDY			Sets the display format for date and time values.	Also controls interpretation of ambiguous date inputs.
db_user_namespace	sighup	Connections and Authentication / Security and Authentication	BOOLEAN	FALSE			Enables per-database user names.	
deadlock_timeout	sighup	Lock Management	INTEGER	1000	0	2147483647	The time in milliseconds to wait on lock before checking for deadlock.	
debug_pretty_print	user	Reporting and Logging / What to Log	BOOLEAN	FALSE			Indents parse and plan tree displays.	
debug_print_parse	user	Reporting and Logging / What to Log	BOOLEAN	FALSE			Prints the parse tree to the server log.	
debug_print_plan	user	Reporting and Logging / What to Log	BOOLEAN	FALSE			Prints the execution plan to server log.	
debug_print_rewritten	user	Reporting and Logging / What to Log	BOOLEAN	FALSE			Prints the parse tree after rewriting to server log.	
default_statistics_target	user	Query Tuning / Other Planner Options	INTEGER	10	1	1000	Sets the default statistics target.	This applies to table columns that have not had a column-specific target set via ALTER TABLE SET STATISTICS.
default_transaction_isolation	user	Client Connection Defaults / Statement Behavior	STRING	read committed			Sets the transaction isolation level of each new transaction.	Each SQL transaction has an isolation level, which can be either "read committed" or "serializable".
default_transaction_read_only	user	Client Connection Defaults / Statement Behavior	BOOLEAN	FALSE			Sets the default read-only status of new transactions.	
dynamic_library_path	superuser	Client Connection Defaults / Other Defaults	STRING	$libdir			Sets the path for dynamically loadable modules.	If a dynamically loadable module needs to be opened and the specified name does not have a directory component (i.e., the name does not contain a slash), the system will search this path for the specified file.
effective_cache_size	user	Query Tuning / Planner Cost Constants	REAL	1000	0	1.79769e+308	Sets the planner's assumption about size of the disk cache.	That is, the portion of the kernel's disk cache that will be used for PostgreSQL data files. This is measured in disk pages, which are normally 8 kB each.
enable_hashagg	user	Query Tuning / Planner Method Enabling	BOOLEAN	TRUE			Enables the planner's use of hashed aggregation plans.	
enable_hashjoin	user	Query Tuning / Planner Method Enabling	BOOLEAN	TRUE			Enables the planner's use of hash join plans.	
enable_indexscan	user	Query Tuning / Planner Method Enabling	BOOLEAN	TRUE			Enables the planner's use of index-scan plans.	
enable_mergejoin	user	Query Tuning / Planner Method Enabling	BOOLEAN	TRUE			Enables the planner's use of merge join plans.	
enable_nestloop	user	Query Tuning / Planner Method Enabling	BOOLEAN	TRUE			Enables the planner's use of nested-loop join plans.	
enable_seqscan	user	Query Tuning / Planner Method Enabling	BOOLEAN	TRUE			Enables the planner's use of sequential-scan plans.	
enable_sort	user	Query Tuning / Planner Method Enabling	BOOLEAN	TRUE			Enables the planner's use of explicit sort steps.	
enable_tidscan	user	Query Tuning / Planner Method Enabling	BOOLEAN	TRUE			Enables the planner's use of TID scan plans.	
explain_pretty_print	user	Client Connection Defaults / Other Defaults	BOOLEAN	TRUE			Uses the indented output format for EXPLAIN VERBOSE.	
extra_float_digits	user	Client Connection Defaults / Locale and Formatting	INTEGER	0	-15	2	Sets the number of digits displayed for floating-point values.	This affects real, double precision, and geometric data types. The parameter value is added to the standard number of digits (FLT_DIG or DBL_DIG as appropriate).
from_collapse_limit	user	Query Tuning / Other Planner Options	INTEGER	8	1	2147483647	Sets the FROM-list size beyond which subqueries are not collapsed.	The planner will merge subqueries into upper queries if the resulting FROM list would have no more than this many items.
fsync	sighup	Write-Ahead Log / Settings	BOOLEAN	TRUE			Forces synchronization of updates to disk.	The server will use the fsync() system call in several places to make sure that updates are physically written to disk. This insures that a database cluster will recover to a consistent state after an operating system or hardware crash.
geqo	user	Query Tuning / Genetic Query Optimizer	BOOLEAN	TRUE			Enables genetic query optimization.	This algorithm attempts to do planning without exhaustive searching.
geqo_effort	user	Query Tuning / Genetic Query Optimizer	INTEGER	1	1	2147483647	GEQO: effort is used to calculate a default for generations.	
geqo_generations	user	Query Tuning / Genetic Query Optimizer	INTEGER	0	0	2147483647	GEQO: number of iterations in the algorithm.	The number must be a positive integer. If 0 is specified then effort * log2(poolsize) is used.
geqo_pool_size	user	Query Tuning / Genetic Query Optimizer	INTEGER	0	0	1024	GEQO: number of individuals in one population.	
geqo_selection_bias	user	Query Tuning / Genetic Query Optimizer	REAL	2	1.5	2	GEQO: selective pressure within the population.	
geqo_threshold	user	Query Tuning / Genetic Query Optimizer	INTEGER	11	2	2147483647	Sets the threshold of FROM items beyond which GEQO is used.	
join_collapse_limit	user	Query Tuning / Other Planner Options	INTEGER	8	1	2147483647	Sets the FROM-list size beyond which JOIN constructs are not flattened.	The planner will flatten explicit inner JOIN constructs into lists of FROM items whenever a list of no more than this many items would result.
krb_server_keyfile	postmaster	Connections and Authentication / Security and Authentication	STRING				Sets the location of the Kerberos server key file.	
lc_messages	superuser	Client Connection Defaults / Locale and Formatting	STRING				Sets the language in which messages are displayed.	
lc_monetary	user	Client Connection Defaults / Locale and Formatting	STRING	C			Sets the locale for formatting monetary amounts.	
lc_numeric	user	Client Connection Defaults / Locale and Formatting	STRING	C			Sets the locale for formatting numbers.	
lc_time	user	Client Connection Defaults / Locale and Formatting	STRING	C			Sets the locale for formatting date and time values.	
log_connections	backend	Reporting and Logging / What to Log	BOOLEAN	FALSE			Logs each successful connection.	
log_duration	userlimit	Reporting and Logging / What to Log	BOOLEAN	FALSE			Logs the duration each completed SQL statement.	
log_error_verbosity	superuser	Reporting and Logging / When to Log	STRING	default			Sets the verbosity of logged messages.	Valid values are "terse", "default", and "verbose".
log_executor_stats	userlimit	Statistics / Monitoring	BOOLEAN	FALSE			Writes executor performance statistics to the server log.	
log_hostname	sighup	Reporting and Logging / What to Log	BOOLEAN	FALSE			Logs the host name in the connection logs.	By default, connection logs only show the IP address of the connecting host. If you want them to show the host name you can turn this on, but depending on your host name resolution setup it might impose a non-negligible performance penalty.
log_min_duration_statement	userlimit	Reporting and Logging / When to Log	INTEGER	-1	-1	2147483	Sets the minimum execution time in milliseconds above which statements will be logged.	Zero prints all queries. The default is -1 (turning this feature off).
log_min_error_statement	userlimit	Reporting and Logging / When to Log	STRING	panic			Causes all statements generating error at or above this level to be logged.	All SQL statements that cause an error of the specified level or a higher level are logged.
log_min_messages	userlimit	Reporting and Logging / When to Log	STRING	notice			Sets the message levels that are logged.	Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, INFO, NOTICE, WARNING, ERROR, LOG, FATAL, and PANIC. Each level includes all the levels that follow it.
log_parser_stats	userlimit	Statistics / Monitoring	BOOLEAN	FALSE			Writes parser performance statistics to the server log.	
log_pid	sighup	Reporting and Logging / What to Log	BOOLEAN	FALSE			Prefixes server log messages with the server PID.	
log_planner_stats	userlimit	Statistics / Monitoring	BOOLEAN	FALSE			Writes planner performance statistics to the server log.	
log_source_port	sighup	Reporting and Logging / What to Log	BOOLEAN	FALSE			Logs the outgoing port number of the connecting host.	
log_statement	userlimit	Reporting and Logging / What to Log	BOOLEAN	FALSE			Logs each SQL statement.	
log_statement_stats	userlimit	Statistics / Monitoring	BOOLEAN	FALSE			Writes cumulative performance statistics to the server log.	
log_timestamp	sighup	Reporting and Logging / What to Log	BOOLEAN	FALSE			Prefixes server log messages with a time stamp.	
max_connections	postmaster	Connections and Authentication / Connection Settings	INTEGER	100	1	2147483647	Sets the maximum number of concurrent connections.	
max_expr_depth	user	Client Connection Defaults / Other Defaults	INTEGER	10000	10	2147483647	Sets the maximum expression nesting depth.	
max_files_per_process	postmaster	Resource Usage / Kernel Resources	INTEGER	1000	25	2147483647	Sets the maximum number of simultaneously open files for each server process.	
max_fsm_pages	postmaster	Resource Usage / Free Space Map	INTEGER	20000	1000	2147483647	Sets the maximum number of disk pages for which free space is tracked.	
max_fsm_relations	postmaster	Resource Usage / Free Space Map	INTEGER	1000	100	2147483647	Sets the maximum number of tables and indexes for which free space is tracked.	
max_locks_per_transaction	postmaster	Lock Management	INTEGER	64	10	2147483647	Sets the maximum number of locks per transaction.	The shared lock table is sized on the assumption that at most max_locks_per_transaction * max_connections distinct objects will need to be locked at any one time.
password_encryption	user	Connections and Authentication / Security and Authentication	BOOLEAN	TRUE			Encrypt passwords.	When a password is specified in CREATE USER or ALTER USER without writing either ENCRYPTED or UNENCRYPTED, this parameter determines whether the password is to be encrypted.
port	postmaster	Connections and Authentication / Connection Settings	INTEGER	5432	1	65535	Sets the TCP port the server listens on.	
preload_libraries	postmaster	Resource Usage / Kernel Resources	STRING				Lists shared libraries to preload into server.	
random_page_cost	user	Query Tuning / Planner Cost Constants	REAL	4	0	1.79769e+308	Sets the planner's estimate of the cost of a nonsequentially fetched disk page.	This is measured as a multiple of the cost of a sequential page fetch. A higher value makes it more likely a sequential scan will be used, a lower value makes it more likely an index scan will be used.
regex_flavor	user	Version and Platform Compatibility / Previous PostgreSQL Versions	STRING	advanced			Sets the regular expression "flavor".	This can be set to advanced, extended, or basic.
rendezvous_name	postmaster	Connections and Authentication / Connection Settings	STRING				Sets the Rendezvous broadcast service name.	
search_path	user	Client Connection Defaults / Statement Behavior	STRING	$user,public			Sets the schema search order for names that are not schema-qualified.	
shared_buffers	postmaster	Resource Usage / Memory	INTEGER	1000	16	2147483647	Sets the number of shared memory buffers used by the server.	
silent_mode	postmaster	Reporting and Logging / When to Log	BOOLEAN	FALSE			Runs the server silently.	If this parameter is set, the server will automatically run in the background and any controlling terminals are dissociated.
sort_mem	user	Resource Usage / Memory	INTEGER	1024	64	2147483647	Sets the maximum memory to be used for sorts and hash tables.	Specifies the amount of memory to be used by internal sort operations and hash tables before switching to temporary disk files
sql_inheritance	user	Version and Platform Compatibility / Previous PostgreSQL Versions	BOOLEAN	TRUE			Causes subtables to be included by default in various commands.	
ssl	postmaster	Connections and Authentication / Security and Authentication	BOOLEAN	FALSE			Enables SSL connections.	
statement_timeout	user	Client Connection Defaults / Statement Behavior	INTEGER	0	0	2147483647	Sets the maximum allowed duration (in milliseconds) of any statement.	A value of 0 turns off the timeout.
stats_block_level	superuser	Statistics / Query and Index Statistics Collector	BOOLEAN	FALSE			Collects block-level statistics on database activity.	
stats_command_string	superuser	Statistics / Query and Index Statistics Collector	BOOLEAN	FALSE			Collects statistics about executing commands.	Enables the collection of statistics on the currently executing command of each session, along with the time at which that command began execution.
stats_reset_on_server_start	postmaster	Statistics / Query and Index Statistics Collector	BOOLEAN	TRUE			Zeroes collected statistics on server restart.	
stats_row_level	superuser	Statistics / Query and Index Statistics Collector	BOOLEAN	FALSE			Collects row-level statistics on database activity.	
stats_start_collector	postmaster	Statistics / Query and Index Statistics Collector	BOOLEAN	TRUE			Starts the server statistics-collection subprocess.	
superuser_reserved_connections	postmaster	Connections and Authentication / Connection Settings	INTEGER	2	0	2147483647	Sets the number of connection slots reserved for superusers.	
syslog	sighup	Reporting and Logging / Syslog	INTEGER	0	0	2	Uses syslog for logging.	If this parameter is 1, messages go both to syslog and the standard output. A value of 2 sends output only to syslog. (Some messages will still go to the standard output/error.) The default is 0, which means syslog is off.
syslog_facility	postmaster	Reporting and Logging / Syslog	STRING	LOCAL0			Sets the syslog "facility" to be used when syslog enabled.	Valid values are LOCAL0, LOCAL1, LOCAL2, LOCAL3, LOCAL4, LOCAL5, LOCAL6, LOCAL7.
syslog_ident	postmaster	Reporting and Logging / Syslog	STRING	postgres			Sets the program name used to identify PostgreSQL messages in syslog.	
tcpip_socket	postmaster	Connections and Authentication / Connection Settings	BOOLEAN	FALSE			Makes the server accept TCP/IP connections.	
TimeZone	user	Client Connection Defaults / Locale and Formatting	STRING	UNKNOWN			Sets the time zone for displaying and interpreting time stamps.	
transform_null_equals	user	Version and Platform Compatibility / Other Platforms and Clients	BOOLEAN	FALSE			Treats "expr=NULL" as "expr IS NULL".	When turned on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. The correct behavior of expr = NULL is to always return null (unknown).
unix_socket_directory	postmaster	Connections and Authentication / Connection Settings	STRING				Sets the directory where the Unix-domain socket will be created.	
unix_socket_group	postmaster	Connections and Authentication / Connection Settings	STRING				Sets the owning group of the Unix-domain socket.	(The owning user of the socket is always the user that starts the server.)
unix_socket_permissions	postmaster	Connections and Authentication / Connection Settings	INTEGER	511	0	511	Sets the access permissions of the Unix-domain socket.	Unix-domain sockets use the usual Unix file system permission set. The parameter value is expected to be an numeric mode specification in the form accepted by the chmod and umask system calls. (To use the customary octal format the number must start with a 0 (zero).)
vacuum_mem	user	Resource Usage / Memory	INTEGER	8192	1024	2147483647	Sets the maximum memory used to keep track of to-be-reclaimed rows.	
virtual_host	postmaster	Connections and Authentication / Connection Settings	STRING				Sets the host name or IP address to listen to.	
wal_buffers	postmaster	Write-Ahead Log / Settings	INTEGER	8	4	2147483647	Sets the number of disk-page buffers in shared memory for WAL.	
wal_sync_method	sighup	Write-Ahead Log / Settings	STRING	fsync			Selects the method used for forcing WAL updates out to disk.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.