Messages posted by: Dave_P

Dave_P wrote:I'll look into the root cause.

OK, it should be fixed now. There was a problem in the XML file that tells StackBuilder what to do.

Bronson_A_2 wrote:Hi Dave,

I know that the PostGIS community actually maintains and updates PostGIS. However, doesn't EnterpriseDB package the PostGIS to make it available with their installer/application builder? I get the feeling my issue is more a problem with a setting on my computer rather than anything actually wrong with PostGIS.

In addition, I will try your suggestion of contacting the PostGIS community.

Thanks.

Sorry, had a pre-coffee moment there. The community maintain the Windows packages, but we do maintain ones for Linux & Mac. Are you running on Mountain Lion? I've just tested here, and found a couple of installers seem to silently exit with no error when run from StackBuilder. They work fine when run manually, so I suggest for now you use StackBuilder to download PostGIS and then unzip and run the installer from the finder or command line. I'll look into the root cause.

Bronson_A_2 wrote:Two years ago, I successfully installed the PostGIS extension with the EnterpriseDB PostgreSQL version 8.4 on Mac OSX.

Recently, I installed the newer PostgreSQL version 9.1. I also installed the PostGIS extension with the application builder. Although I received no install errors, the PostGIS functions are not found in the version 9.1 server.

Is the previous install (8.4) interfering with the installation of PostGIS with PostgreSQL 9.1? How do I get PostGIS to work on the new version?

Thanks.

Hi

The previous installation shouldn't cause any problems - however, EnterpriseDB don't maintain the PostGIS package in StackBuilder; the PostGIS community do. I'd suggest asking for help on their mailing lists.

poshakmaheshwari wrote:Hi all ,
Can someone tell me where can i find the latest version of postgres msi(specifically msi installer).
That will be of great help

Thanks

Hi

The MSI installer is not maintained by EnterpriseDB, but by the PostgreSQL community (specifically me as it happens, but not as an EDB employee). Downloads can be found on ftp.postgresql.org.

BUT: The MSI installer is obsolete now and has long been superceded by the installers EnterpriseDB maintain (http://www.enterprisedb.com/products-services-training/pgdownload). I am currently only maintaining bug-fix releases of PostgreSQL 8.3 for the community, and that will become entirely obsolete and unsupported next February. You should only use the MSI installer to upgrade an existing MSI installation at this point.

hagzag wrote:What I am trying to achieve is creating a zip / tar.gz file with potgresql with all its inter-dependencies and then at buidl time download and extract the zip / tar.gz
[running as the user which instantiated the build], start the server, set up a user, pass & database, run my tests, stop the server then remove the installation.

Hi

We offer plain tarballs/zip files of the binaries as well as the installers: http://www.enterprisedb.com/products-services-training/pgbindownload

Regards, Dave.

cdelgado wrote:Hi,

Just found out that the command --help lists more options (not documented in the website, BTW...)

Carlos

The installer you mention is not from EnterpriseDB - it's the old, unmaintained PostgreSQL installer.

--help will work with ours too though.

consultus wrote:Thanks, I tried this but I get the below error;

SQL error:

ERROR: encoding UTF8 does not match locale en_AU.ISO8859-1
DETAIL: The chosen LC_CTYPE setting requires encoding LATIN1.
In statement:
CREATE DATABASE drupal ENCODING 'UTF8' TEMPLATE template0;

where is it getting the locale setting? the OS?

Oh, urgh. I guess that workaround is no good any more. If you haven't done anything else with your installation yet (and don't have any other of our packages installed), it's probably easiest to just uninstall/reinstall. First, run the uninstaller:

sudo open /Library/PostgreSQL/9.1/uninstall-postgresql.app

Then, get rid of the data directory and to be on the safe side, registry file (those get retained after an uninstall in case you're just reinstalling the software and don't want to delete your data):

sudo rm /etc/postgres-reg.ini
sudo rm -rf /Library/PostgreSQL/9.1

Finally, reinstall and pick the appropriate locale (ie. en_AU.UTF

to work with Drupal. Note that most other apps are less sensitive to this issue - Drupal is a bit of a pain in that regard.

consultus wrote:Hi Dave, One last question. I made the mistake of setting Locale=en_AU.ISO8859-1 rather than UTF8. Drupal does not seem to like it. Can I simply change Locale=en_AU.ISO8859-1 to Locale=UTF8 in the postgres-reg.ini ? My OS is 10.7.3

Thanks.

No, the postgres-reg.ini file just records the installation options to make things easier for other installers that need to discover how the server was installed.

Once the installation is run, you cannot change the cluster-wide encoding (unless you delete the data directory and re-run initdb). You can create databases in different encodings though, if you use template0 as the template, eg:

CREATE DATABASE drupal ENCODING 'UTF8' TEMPLATE template0;

consultus wrote:
I ran the dmg file linked here http://www.postgresql.org/download/macosx/

Download for Mac OS X 10.4+

The installer did not ask or tell me where it installed the binary files. It just ran.

The installer linked from there will ask for the installation directory on first installation, but if it detects an existing installation (from our installers) it will just upgrade it without asking for the location. Could it be that your previous installation was configured in a non-standard way that's causing confusion now?

FYI, the default installation directory is under /Library/PostgreSQL, so it would be worth checking there.

Please post the contents of /etc/postgres-reg.ini to help with any further debugging.

consultus wrote:
Searching the web, I see references that only Lion Server ships with pqsl

Lion server ships with the entire PostgreSQL database server. Lion desktop includes the client utilities - psql, pg_dump etc. - and libpq.

consultus wrote:Thanks Dave,

I ran the below with no new result;

psql -h /tmp -U postgres
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

How do I ensure the correct binary's are used? Below is my config
Some of those folders don't exist. Like include under /usr

Jeffs-MacBook-Pro-2:local Jeff$ pg_config
BINDIR = /usr/bin
DOCDIR = /usr/share/doc/postgresql
...

Those are almost certainly the settings that Apple used (they ship the psql client with Lion). Can you confirm that you installed the EnterpriseDB package, and into what directory?

consultus wrote:I ran the one click installer on my 10.7.3 Mac but I get errors when I try to use it.

Jeffs-MacBook-Pro-2:local Jeff$ psql
psql: could not connect to server: Permission denied
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

is 10.7.3 supported?
is there an uninstall I can run?

Thanks

Yes, Lion is fully supported. You're using the Apple-supplied psql binary though, which is configured with a different location for the default Unix Domain Socket. Try something like "psql -h /tmp", or make sure you use the psql binary shipped with the installer which will default to the appropriate location. You'll probably also want to add "-U postgres" to connect as the right user (whichever binary you use).

Hi

ryanschuermann wrote:
The 32bit install file above defaults to installing in the Program Files (x64) dir and FORCES the x64 install name.
The Service ID is even postgresql-x64-9.1

Look a little more closely - it's "Program Files (x86)", not x64, following Microsoft's convention of putting 32bit apps in the (x86) program files directory.

aaaaaaaaaa_aaaaaaa_3 wrote:I am sorry but I can't find OpenSSL in StackBuilder.
In my computer I have PostgreSQL 8.4.8 installed, the latest being 8.4.10.

Maybe OpenSSL in not available in StackBuilder for PostgreSQL 8.4 or is there anything i didn't see ?

You won't find OpenSSL listed in StackBuilder. Where it's needed, it's included in the individual packages. For example, the Apache/PHP installer will install the SSL libraries that Apache requires, as will the PostgreSQL or Postgres Enterprise Manager installers.

aaaaaaaaaa_aaaaaaa_3 wrote:
If someone could add OpenSSL in StackBuider it would be great.

All the apps we provide via StackBuilder include any OpenSSL libraries that are required, including PostgreSQL itself. We don't provide standalone packages for any apps or libraries that aren't specifically written or compiled to work with PostgreSQL.

Basil_Bourque wrote:What's the current status?

I see Apple is bundling Postgres 9.0.4 with Lion 10.7.2.

I'm talking about the regular client/desktop-edition of Lion, not the Server edition.

And I am focused on a "clean install" of Lion, not upgrading Snow Leopard where Postgres was already installed.

Hi,

The current versions of the one-click installer for 9.0.6 and 9.1.2 are fully supported on Lion. They should work fine for you. The Apple supplied version only runs as a server on the Server edition of Lion. On the desktop version, they just supply the client tools (psql etc.) and libpq.

Robert_D wrote:I've been using PEM since it was in beta and one of the big pieces that I thought was missing from the start was the ability to send an email when an alert occurs. I put together the following script to generate an email whenever an alert is generated or the alert status changes: http://dbascripting.com/scripts/16. It uses pgmail which must be configured before creating the function and trigger.

This feature should be available in an upcoming release of PEM, so this is a temporary solution if you are using PEM to monitor your enterprise Postgres servers like I am.

HTH,
Bobby

Thanks Bobby - hopefully that will be useful for others. As you note, this feature will be in an upcoming release of PEM - 2.1.0, which is currently slated for release in Q1 2012.

Hi,

With 2.0.1 you can store the password in the agent/server binding (on the PEM Agent tab of the Server properties dialogue).

However, I should point out that anyone with root access to the server can trivially access the database anyway. Removing the password from ~root/.pgpass maybe keeps them out for 30 seconds longer, but that's about all.

neilc2011 wrote:Hi there

Thank you for your reply.

I started in single use mode, as this was all that would work. I renamed the file /etc/sysctl.conf and my system starts fine.

Here is a copy of the file that the installer wrote.

kern.sysv.shmmax=33554432
kern.sysv.shmmin=1
kern.sysv.shmmni=256
kern.sysv.shmseg=64
kern.sysv.shmall=8192

I've got 4gb of ram in my machine.

Not sure where to go from here really.

Very bizzarre - that's a standard config that the installer uses on any machine that doesn't have the default settings overridden already. It's been used in tens, probably hundreds of thousands of machines in the past, including my own with both 4 and 8GB of RAM.

I used to use the following settings on an old machine with just 2GB RAM. It would be interesting to see if those settings work:

kern.sysv.shmmax=1610612736
kern.sysv.shmall=393216
kern.sysv.shmmin=1
kern.sysv.shmmni=32
kern.sysv.shmseg=8
kern.maxprocperuid=512
kern.maxproc=2048

neilc2011 wrote:Hello.

Please help me. I've downloaded and run the latest one click installer on my macbook pro running osx 10.5.8.

The installer said it had adjusted some memory settings and I must reboot which I did. Now my macbook will not start.

I get the Apple logo and the spinning graphic and then it just switches off.

I tried to start in safe mode using the shift key but safe mode does not appear.

Please help. Your installer just killed my machine !

thanks

Hi,

I'd be suspicious of something else - all the installer has done at this point is create a /etc/sysctl.conf file with some shared memory settings in it, which OSX will ignore if it doesn't like.

To undo the changes the installer made, all you need to do is remove /etc/sysctl.conf (the installer will only create it if it doesn't already exist), and reboot. As you cannot boot normally at present, I would suggest booting from your OSX installation media, which should allow you to mount the main disk (it may do that automatically, I forget) and remove the file before rebooting.

If the machine still won't boot after removing the file, there's something else wrong (similarly, if it won't boot from the OSX installation media).

HTH.

Sachin_S wrote:You need to set the LD_LIBRARY_PATH to /opt/PEM/agent/lib folder
as export LD_LIBRARY_PATH=/opt/PEM/agent/lib

That should happen automatically if you start the agent using the init script:

# service pemagent start

Chris_Rowling wrote:I have installed PgSql 8.4.4-1 on my mac mini and think Dave_P's install system is a very neat piece of work!

I should also add that it's not just my work - the current team includes Sachin, Ashesh, Dharmendra, Tushar and Sujeet who deserve most of the credit.

Chris_Rowling wrote:I have installed PgSql 8.4.4-1 on my mac mini and think Dave_P's install system is a very neat piece of work!

I am running macosx server snow leopard.

Prior to running the apache/php part of the install for Drupal etc, my server has Apache running already.

Does the installer detect the running server and configure itself appropriately or should I configure the links manually

Thanks Chris.

The StackBuilder Drupal package needs to user the StackBuilder distribution of Apache & PHP. It cannot use the Apple supplied server, or one you've built yourself. The reason for this is that we want to keep the entire stack independent of the Apple server as it doesn't come with all the build options/modules that we use, and we have no control over what changes Apple might make in future updates. It's significantly easier to manage the entire stack ourselves.

It is possible that you could hack it about to make it work, but I wouldn't advise doing so.

mark_Smith wrote:
However, when I go into pgAdmin there is absolutely no evidence of a table called test_copy, nor of any data. I guess I am misunderstanding what pgAdmin is for, but I would have thought that at least the table would show up? Under "test" all I see are catalogs, schemas and replication.

Hi Mark,

Tables live in a schema, so if you expand the 'Schemas' node you see, and (probably) the 'public' schema, you should see a bunch more collection nodes including 'Tables', which should contain your table.

Artem_Povaluhin wrote:Why PostgreSQL installer creates a service account as a normal user, instead of creating it as a system user.
just like that: #sudo adduser --system --home ... --group postgres
?

Not all versions of adduser support the --system option.

Stephen_Cox wrote:just forund this thread via google. Also have this problem. Gonna reset into 32bit mod to install. Want a log?

-thanks

Stephen Cox

Stephen; thanks, but we don't need the log. The problem has been identified and resolved by Bitrock (who provide the installer technology), and the issue will be resolved in the next update to PostgreSQL.

Regards, Dave