[GENERAL] Why don't dumped files parse in pgAdmin3 query editor?
Here's something I've always wondered. When you dump a database, the dumped file looks like ordinary SQL, but if I load it into a query editor window and try to execute it, I always get syntax errors. The specific errors vary, but it always makes it impossible to reload the data that way. In the past I've just used psql -f [file] [schema] to reload them, but I'm trying to do this on Windows, and I can't seem to get anything to work from the command shell, so I'm really stuck. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Why don't dumped files parse in pgAdmin3 query editor?
Quoting Magnus Hagander [EMAIL PROTECTED]: It should work perfectly fine to restore it using psql -f on Windows as well, I'd recommend that you look into why that's not working and try to fix that instead. The main problem I'm having is that any command I try to use with psql, even psql /?, causes it to prompt me for a password, and it tells me my password is wrong no matter what username/passsword combination I try. Beyond that, I really don't know what the correct syntax to use in the Windows command shell is. Would it be psql -f or psql /f? ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] I'd love to know what the rest of this error message is.
I've been using PostgreSQL on Mac OS X for a few years, but now I'm trying to install it on a WIndows computer so someone else can use it, and I'm getting the following error message when I try to advance beyond the Service Configuration screen in the installer: Your local 'Administrators' group contains 'Authenticated Users'. This is a common configuration error that causes security issues. For this reason, Postgr That's it. Apparently the whole error message doesn't fit in the error dialog, but there's no way to resize the window. Does anybody know what the rest of this message might be? Bonus points if you can explain what it means, and especially if you can explain what to do about it. I suspect this is more a WIndows problem than a PostgreSQL problem, but I'm afraid I don't know that much about Windows. I'm a Mac/Unix kind of guy, and I try to avoid using WIndows whenever possible because this kind of stuff always happens. Thanks! ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] I'd love to know what the rest of this error message is.
Quoting Bill Moran [EMAIL PROTECTED]: In response to [EMAIL PROTECTED]: I've been using PostgreSQL on Mac OS X for a few years, but now I'm trying to install it on a WIndows computer so someone else can use it, and I'm getting the following error message when I try to advance beyond the Service Configuration screen in the installer: Your local 'Administrators' group contains 'Authenticated Users'. This is a common configuration error that causes security issues. For this reason, Postgr That's it. Apparently the whole error message doesn't fit in the error dialog, but there's no way to resize the window. Does anybody know what the rest of this message might be? Bonus points if you can explain what it means, and especially if you can explain what to do about it. I suspect this is more a WIndows problem than a PostgreSQL problem, but I'm afraid I don't know that much about Windows. I'm a Mac/Unix kind of guy, and I try to avoid using WIndows whenever possible because this kind of stuff always happens. I don't know 100%, but it looks like the authenticated users group is a member of the administrators group. This means that anyone who logs in to the workstation is an administrator. It's a complete lack of security, but it's also very common (in my experience) for Windows workstations. I'm guessing that the PG installer is being anal and refusing to allow you to install on such a poorly configured system, but that part I don't know. My suggestion would be to fix the users/groups on the Windows system so there is a special administrative user, then remove authenticated users from the administrator group. When I saw this error I immediately went to the Local Users and Groups control panel to see if I could figure out what the heck it was talking about, and I swear there is no group called Authenticated Users. That's what's so baffling about this, apart from the incomplete error message. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
