Questions with no accepted solutions

Hi folks,

I used PostgreSQL 8.4.1 on a Linux server for a long time and it was running great, but I noticed one day in one of the databases I use, the following problem exists:

An error occurred while performing the operation.

An error occurred while performing the operation.

Error: column c.reltriggers does not exist

Position: 190

Show more details about the problem.

More Details

  • 2262 views
  • 1 answers
  • 20 votes

Hi,

I bought a brand new computer, running under Microsoft Windows 7 64 bit.

I am trying to install Holdemmanager after downloading the complete setup, getting an error message that states:

Sorry, could not install postgressql.

I even uninstalled it from the control panel and get another set of downloading postgres even previous versions, but it did not work at all and it got stuck somewhere in the installation.

  • 2279 views
  • 1 answers
  • 20 votes
  • 1160 views
  • 1 answers
  • 20 votes

Hi,

I am a pgsql user. I had a problem with installing postgres8.1, the error occurs at the 4th step of installation. The error stated is as follows:

Data directory error:  The specified data directory is not empty

If you have an existing database with the same major version number, you do not need to initialize a database cluster. If you have an existing database with the same major version you need to backup your old database and create a new one.

  • 2357 views
  • 1 answers
  • 20 votes

Hi,

While I am Installing PostgreSQL, on my system this error message appears on my screen:

 

Account Error

Invalid username specified: Logon failure: unknown user name or bad password.

While I am working with the configuration screen, that above an error I mentioned pops up. I used the account name postgre and supplied my own password.

  • 1010 views
  • 1 answers
  • 20 votes

Hi,

My problem is all about my installation of postgreSql, there some failures or error that I can't figure out why it fails to run initdb.,And this is the initdb. log: The files belonging to this database system will be owned by user "SYSTEM". This user must also own the server process.

The database cluster will be initialized with locale English_Canada. The default text search configuration will be set to "english".,initdb: could not access directory "C:/Program Files/PostgreSQL/8.3/data": No such file or directory. As of now what I did is just turn the UAC off. Stated below is the original text of the error, please help me find ways to solve this. What is the reason for this error? Failed to run initdb: 1!

  • 4242 views
  • 1 answers
  • 20 votes

I have a installation problem that says:  

This  error showed up when I’m on the process of  installing postgres 8.3.1. With postgres automatically creating its own user account, the installer show me the error that I have mentioned. I checked on the Task Manager and there are 4 postgres.exe processes that can be seen. This installer makes accounts that can log on locally as a service. This is supposedly not a problem.

I already  manually ensured that the account has the privilege in "Local Security Settings", and the account I run PGinstaller belongs to the administrative account. I already deleted all the older ones in the Local Users and Groups dialog.

  • 1994 views
  • 1 answers
  • 20 votes

Hello guys,

 I am using Ruby under Windows XP 32bit

DB: postgreSQL 8.4, when trying a to get connected I get this message somewhat like this

ruby.exe – Ordinal Not Found

The ordinal 284 could not be located in the dynamic link library SSLEAY32.dll

My idea, but somewhat a sort of a guess is that it seems to be some conflict between the ssleay32 shipped with postgres and the ruby. I understand that I could have gem postgres-pr, but it would be preferable for me to use the ruby-postgres than any other, for I already use this on all my set-ups.

  • 1475 views
  • 1 answers
  • 20 votes

Hi,

I am on the process of making codes, while on testing I encountered this error message regarding SQL.

It seems there is a problem with my database that is not running well. I looked into my drive and searched, but didn't find libpq.dll, but I am pretty sure that I have PostgreSQL installed successfully. Because I can use pgAdminIII to manage databases, what came to my mind is that, why is the system looking for a file, while my installation of PostgreSQL is successful, and no error message was posted while installing it? Please help me find why the system is asking me for a file libpq.dll.

Thanks.

 

  • 3017 views
  • 1 answers
  • 20 votes

Hi folks,

I have some PostgreSQL driver issue while working, this is the error I encountered.

ClassNotFoundError!

Msg: org.postgresql.Driver

This class may not have been found: org.postgresql.Driver

I am using Jasper report. I am on my hands in creating reports from PostgreSQL database using Jasper report, database is not installed on my machine. I already installed JavaServer Pro 3.0 and iReport 3.0.0. I started javaserver and it seems to be doing great since its up and Running and I start iReport, it opens cmd window and open iReport.

  • 2161 views
  • 1 answers
  • 20 votes