Hello !
The RC2 is great but :
I use an other filesystem for the data.
So I have C:\Program file\PostgreSQL ... and I have F:\PostgreSQL\8 .0.0-beta4\data.
In the file C:\Program Files\PostgreSQ L\8.0.0-beta4\data\post gresql.conf I modify the files locations :
data_directory = 'F:/PostgreSQL/8.0.0-beta4/data'
hba_file = 'F:/PostgreSQL/8.0.0-beta4/data/pg_hba.conf'
ident_file = 'F:/PostgreSQL/8.0.0-beta4/data/pg_ident.conf'.
The file F:\PostgreSQL\8 .0.0-beta4\data\pg_h ba.conf contain :
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.0.0/24 md5
# IPv6 local connections:
#host all all ::1/128 md5
On the localhost (192.168.0.10) with pgAdmin III (1.20 RC2),
I can't connect like localhost (localhost, beta4, pgsql-8.0.0-beta4, 5432, template1, postgres, ****)
but I can connect like an host (192.168.0.10, beta4, , 5432, template1, postgres, ****) !?
Before I split the data on an other disk I can connect as 'localhost'.
Shall I make a mistake, is it a bug ?
Some wishes :
- The win32 install let choose an alternate disk for the data ...
- The win32 install use the user variable PGDATA for the links towards configuration files (in ex. %PGDATA%\pg_hba .conf), it's more efficient when putting data on another disk.
You're doing a great job !
Best regards.
Luc ROLLAND 4 5757
=?iso-8859-1?Q?Secr=E9tari at?= <et*@rolland-fr.com> writes: The file F:\PostgreSQL\8 .0.0-beta4\data\pg_h ba.conf contain : # TYPE DATABASE USER CIDR-ADDRESS METHOD local all all md5 # IPv4 local connections: host all all 127.0.0.1/32 md5 host all all 192.168.0.0/24 md5 # IPv6 local connections: #host all all ::1/128 md5
On the localhost (192.168.0.10) with pgAdmin III (1.20 RC2), I can't connect like localhost (localhost, beta4, pgsql-8.0.0-beta4, = 5432, template1, postgres, ****) but I can connect like an host (192.168.0.10, beta4, , 5432, template1, = postgres, ****) !?
What error message do you get exactly?
Before I split the data on an other disk I can connect as 'localhost'.
I wonder whether you got confused about which set of configuration files
is being used.
regards, tom lane
---------------------------(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
When I connect as localhost I obtain :
"Error connecting to the server: couldnot connect to server: Connection
refused (0x0000274d/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432 ?"
My pg-hba.conf seems correct (transmitted).
----- Original Message -----
From: "Tom Lane" <tg*@sss.pgh.pa .us>
To: "Secrétaria t" <et*@rolland-fr.com>
Cc: <pg***********@ postgresql.org>
Sent: Friday, November 19, 2004 5:02 PM
Subject: Re: [GENERAL] PostegreSQL 8.0.0 Beta4 Win32 =?iso-8859-1?Q?Secr=E9tari at?= <et*@rolland-fr.com> writes: The file F:\PostgreSQL\8 .0.0-beta4\data\pg_h ba.conf contain : # TYPE DATABASE USER CIDR-ADDRESS METHOD local all all md5 # IPv4 local connections: host all all 127.0.0.1/32 md5 host all all 192.168.0.0/24 md5 # IPv6 local connections: #host all all ::1/128 md5
On the localhost (192.168.0.10) with pgAdmin III (1.20 RC2), I can't connect like localhost (localhost, beta4, pgsql-8.0.0-beta4, = 5432, template1, postgres, ****) but I can connect like an host (192.168.0.10, beta4, , 5432, template1, = postgres, ****) !?
What error message do you get exactly?
Before I split the data on an other disk I can connect as 'localhost'.
I wonder whether you got confused about which set of configuration files is being used.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
=?iso-8859-1?Q?Secr=E9tari at?= <et*@rolland-fr.com> writes: When I connect as localhost I obtain : "Error connecting to the server: couldnot connect to server: Connection refused (0x0000274d/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432 ?"
"Connection refused" is a system-level error; that implies that the
postmaster isn't listening on that port at all. Check your
listen_addresse s setting.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Tom Lane wrote: regards, tom lane
Tom,
From the content of some of your posts I gather that you are a contributor
to the PostgreSQL development effort.
I just wanted to say thanks for such a fine applications.
--
--
GreyGeek This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Scaramouche |
last post by:
is there an equivalent to unixs' ps command in perl?
i was writing some win32 scripts and i needed a listing of specific
processes. i could perhaps grep through a list of running processes but how
can i attain that through perl?
thanks
|
by: RL |
last post by:
Hi all,
I am new and am lost with Win32::Process stuff.
I want on perl script to start a process, then another perl script to
terminate the same process.
I can start a process using...
-------------------------------------------------------
use Win32::Process;
|
by: Bryan Parkoff |
last post by:
Please provide me the information when it is not in the correct
newsgroups. I have been using C and C++ language for a long time when it is
time for me to learn Win32 API functions that they can be written in C and
C++ language.
Please give me an advice where I should post to discuss this topic to
the correct newsgroups. Also, where can I obtain the best textbook to learn
and understand how Win32 API functions work in C / C++ language. ...
|
by: Marc G. Fournier |
last post by:
Well folks, we are now coming into the home stretch of another long
development cycle, and its time for more vigorous and extensive testing
....
Last night, we bundled up Beta4, which is the first one that we've
officially announced "publicly", with the other 3 having been only
announced on -hackers ...
This release, depending on the bug reports received, will most likely flow
into our first Release Candidate by end of next week, so...
|
by: Tony Johansson |
last post by:
Hello!
I just wonder what the difference is between a native win32-app and MFC.
What I know is that you can use Win32 API in both cases.
I think an MFC application is connected with a GUI which a win32 is not. You
may correct me if I'm wrong on this point.
//Tony
| |
by: BARTKO, Zoltán |
last post by:
Hello folks,
I have installed PgSQL8 beta4 via pginstaller to WinXP. I must tell
you I am more familiar with Linux, so maybe my problem is trivial to
solve:
I made myself a table with PgAdmin III (I was lazy to use psql) that
I tried to reach via ODBC. I created connection to my database,
supplied a user, server, etc., all that was needed.
|
by: jbenezech |
last post by:
Hi all ,
I have a perl/java app running under Win32. The application consists of a perl service (Win32::Daemon) and of java classes. The perl service calls every xx hours java classes to perform some action.
The java call looks like this:
Win32::SetChildShowWindow(0);
Win32::Process::Create(
|
by: somuchh8 |
last post by:
Hi, I'm having a lot of trouble with the Win32::Spawn module in perl. Here is my situation, I have a Win32::Spawn call which looks like this:
my $success = undef;
my $cmdline = EBDTools::os_path("${nh_home}/web/aview/modules/svcrsp-ng/saSync.pl");
$success = Win32::Spawn($^X, "${^X} $cmdline ${optfile}", $pid);
if (! $success) {
my $lasterr = Win32::GetLastError();
return_configerror("Failed to create commit / sync process...
|
by: Perl Beginner |
last post by:
Good morning all,
I had to reinstall Perl (ActivePerl 5.10.0 Build 1004) on my computer (Windows XP), the install went fine. however, I'm having issues loading Win32-GuiTest using the repository in PPM. the steps i took are:
1. saved Win32-GuiTest-1.50.5.zip from the search.cpan.org website
2. unzipped in the location c:/Perl/Win32-GuiTest
3. opened the PPM window and went to Edit-Preferences and clicked the repositories tab
4. i put...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |