473,834 Members | 2,138 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

datpath error

Hello all,

I've installed the new Win32 version of 8.0-beta1, running as a
service. When I connect to it using pgAdmin III and attempt to list
databases, I get an error: 'Column "datpath" does not exist.' I got
the same error reported when starting postmaster from the command
line using pg_ctl.

It's not causing me any real problems, apart from having to use psql
rather than pgAdmin for administration.

--Ray.

-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
ro*@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1
5 1953
"Raymond O'Donnell" <ro*@iol.ie> writes:
I've installed the new Win32 version of 8.0-beta1, running as a
service. When I connect to it using pgAdmin III and attempt to list
databases, I get an error: 'Column "datpath" does not exist.'


You need a newer pgAdmin.

regards, tom lane

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

Nov 23 '05 #2
Hello,

I had posted my problem before but guess it didnt get
thru correctly. Sorry for the repeatation :)

I am facing a strange problem with pg_hba.conf. I know
I am doing something very stupid.

I had a user kirk who had a pg server running under
him. We had a database by the name kirk and everything
was fine. Then he left the job and we had a new user.
We started the pg using initdb and gave all permission
to the data directory to joe(new user). Now we cant
seem to start login to the server at all.

createuser, createdb etc. all giving the same error:

No entry defined in pg_hba.conf for localhost, user
jor, database template1.

I have checked pg_hba.conf and I have the sentence:

host all all 192.168.0.0 255.255.255.255 trust

but for no avail.

in postresql.conf i have tcp_socket set to true.

What I am doing wrong? In despair..

Regards,
Karam


_______________ _______________ ____
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

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

Nov 23 '05 #3
Karam Chand <ka***********@ yahoo.com> writes:
createuser, createdb etc. all giving the same error: No entry defined in pg_hba.conf for localhost, user
jor, database template1.


This is probably complaining about the lack of a "local" line,
not a "host" line.

regards, tom lane

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

http://archives.postgresql.org

Nov 23 '05 #4
Well from:

http://www.postgresql.org/docs/7.3/s...ntication.html

local
This record matches connection attempts using Unix
domain sockets. Without a record of this type,
Unix-domain socket connections are disallowed
Since I am connecting from my linux box, it might be
the problem. I am in home now - will check it agin
tomorrow in office. damn no SSH to the linux box.

by the way, i have one question. since the old user
left the job and we deleted his account who owns
postgresql and its data? does the old database with
his name which we used to work still exists? I am
little confused on this issue as I come from mySQL
background and we didnt have usernames based on the
Linux usernames?

The postgresql book by wrox tells us to create a user
postgres using "useradd" command but when I look into
User & groups using RH9.1 configuration tool I dont
see any such users but the corresponding "useradd
postgres" fails. Little confusing...dam n my
intelligence...

This leads me to another question: can somebody point
me to a doc that teaches me usermanagement and default
databases (template0 and template1) in newbie terms.

Thanks in advance.

Regards,
Karam

--- Tom Lane <tg*@sss.pgh.pa .us> wrote:
Karam Chand <ka***********@ yahoo.com> writes:
createuser, createdb etc. all giving the same

error:
No entry defined in pg_hba.conf for localhost,

user
jor, database template1.


This is probably complaining about the lack of a
"local" line,
not a "host" line.

regards, tom lane



_______________ _______________ ____
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 23 '05 #5
> The postgresql book by wrox tells us to create a user
postgres using "useradd" command but when I look into
User & groups using RH9.1 configuration tool I dont
see any such users but the corresponding "useradd
postgres" fails. Little confusing...dam n my
intelligence...


Have a look at the file /etc/passwd. It lists all the users on the
system (if you use the standard authentication method and not some
network stuff like NFS or the like). "man 5 passwd" should explain the
file format for you. RHs configuration tool probably doesn't tell you
about all users but only about those in the group of "living people"
(usually "users"). Look for a config option like "Show all users" or
"Show system users".
Have fun!

Yours
Arthur

---------------------------(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

Nov 23 '05 #6

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

Similar topics

2
4386
by: AIM | last post by:
Error in msvc in building inheritance.obj to build hello.pyd Hello, I am trying to build the boost 1.31.0 sample extension hello.cpp. I can not compile the file inheritance.cpp because the two files containing some templates: adjacency_list.hpp and mem_fn.hpp can not compile. Does anyone have any solutions?
5
16266
by: Tony Wright | last post by:
Hi, I am having a problem installing an msi for a web site. The error message I am getting is: "The specified path 'http://mipdev05/features/Fas2' is unavailable. The Internet Information Server might not be running or the path exists and is redirected to another machine. Please check the status of this virtual directory in the Internet Services Manager."
1
8422
by: Aravind | last post by:
we have two files: 1. rc4.c (defines one function "create_pin()") 2. MyImpl.c(calling the function "create_pin()"),This implements JNI method. 1.When I am trying to create .dll file with one file rc4.obj(rc4.c),it is creating the .dll file without any error. Command : ILINK32 rc4.obj 2.But,when we are trying to create .dll file with two .obj files with following errors.
1
6415
by: yanwan | last post by:
I met this problem in executing a c++ project in visual studio. Does anyone have suggestions to resolve "error lnk 2001"? --------------------Configuration: reconstruction - Win32 Debug-------------------- Linking... icarus_camera.obj : error LNK2001: unresolved external symbol _dgels_ icarus_leastsquares.obj : error LNK2001: unresolved external symbol _dgels_ icarus_maths.obj : error LNK2001: unresolved external symbol _dgels_...
5
5723
by: Enos Meroka | last post by:
Hallo, I am a student doing my project in the university.. I have been trying to compile the program using HP -UX aCC compiler, however I keep on getting the following errors. ================================================================= Error 19: "CORBAManagerMessages.h", line 4 # Unexpected 'std'. using std::string; ^^^
13
6622
by: deko | last post by:
I use this convention frequently: Exit_Here: Exit Sub HandleErr: Select Case Err.Number Case 3163 Resume Next Case 3376 Resume Next
7
5035
by: p | last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying. I created the websetup and built the MSI, have the bundled version. Copied to webserver and ran Websetup.msi. Said I had to remove old version, which I did, then reran WebSetup.msi and keeps giving me this error. "The installer was interrupted...
2
19506
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge. I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...
0
2897
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge. I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...
0
9796
marktang
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...
0
10503
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10214
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9326
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 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...
1
7754
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5624
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5790
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3973
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3079
bsmnconsultancy
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...

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.