Re: [Ledger-smb-users] LSMB 1.3.5 and PostgreSQL 9.1

2011-11-23 Thread Chris Travers
On Wed, Nov 23, 2011 at 7:19 AM, Roderick A. Anderson wrote: > Remember that this is from the prepare-company-database.sh script and > maybe I didn't make it clear that this is a fresh install.  Not an upgrade. Bug report filed > > I'll try running the pieces of the script manually to avoid the

Re: [Ledger-smb-users] LSMB 1.3.5 and PostgreSQL 9.1

2011-11-23 Thread Roderick A. Anderson
Chris Travers wrote: > 2011/11/23 Philippe Schelté : >> Le 23/11/2011 01:10, David A. Bandel a écrit : >>> >>> Umm. No, you don't. The CREATE EXTENSION does this. With 9.1, >>> there's a new structure. To check, run psql: >>> psql -U postgres your_database >>> at the SQL prompt (database=#) ente

Re: [Ledger-smb-users] LSMB 1.3.5 and PostgreSQL 9.1

2011-11-23 Thread Chris Travers
2011/11/23 Philippe Schelté : > Le 23/11/2011 01:10, David A. Bandel a écrit : >> >> >> Umm. No, you don't.  The CREATE EXTENSION does this.  With 9.1, >> there's a new structure.  To check, run psql: >> psql -U postgres your_database >> at the SQL prompt (database=#) enter: >> \dx >> >> you should

Re: [Ledger-smb-users] LSMB 1.3.5 and PostgreSQL 9.1

2011-11-23 Thread Philippe Schelté
Le 23/11/2011 01:10, David A. Bandel a écrit : > > > Umm. No, you don't. The CREATE EXTENSION does this. With 9.1, > there's a new structure. To check, run psql: > psql -U postgres your_database > at the SQL prompt (database=#) enter: > \dx > > you should see something like this: >

Re: [Ledger-smb-users] LSMB 1.3.5 and PostgreSQL 9.1

2011-11-22 Thread David A. Bandel
2011/11/22 Philippe Schelté : > On Mon, 21 Nov 2011 17:02:34 -0800, Chris Travers wrote: >>> The directory /usr/pgsql-9.1/share/extension/ has these files. >>> >>> -rw-r--r-- 1 root root  4839 Sep 23 02:26 pg_trgm--1.0.sql >>> -rw-r--r-- 1 root root   177 Sep 23 02:26 pg_trgm.control >>> -rw-r--r--

Re: [Ledger-smb-users] LSMB 1.3.5 and PostgreSQL 9.1

2011-11-21 Thread Philippe Schelté
On Mon, 21 Nov 2011 17:02:34 -0800, Chris Travers wrote: >> The directory /usr/pgsql-9.1/share/extension/ has these files. >> >> -rw-r--r-- 1 root root  4839 Sep 23 02:26 pg_trgm--1.0.sql >> -rw-r--r-- 1 root root   177 Sep 23 02:26 pg_trgm.control >> -rw-r--r-- 1 root root  4092 Sep 23 02:26 >> p

Re: [Ledger-smb-users] LSMB 1.3.5 and PostgreSQL 9.1

2011-11-21 Thread Chris Travers
Hi; On Mon, Nov 21, 2011 at 4:24 PM, Roderick A. Anderson wrote: > I'm doing a semi-automated installation and have run into some problems > trying to create a new company database. > > This is a fresh(-ish) install into a Linux-Vserver guest running CentOS > 5.7.  I've installed Perl 5.14.2 usin

[Ledger-smb-users] LSMB 1.3.5 and PostgreSQL 9.1

2011-11-21 Thread Roderick A. Anderson
I'm doing a semi-automated installation and have run into some problems trying to create a new company database. This is a fresh(-ish) install into a Linux-Vserver guest running CentOS 5.7. I've installed Perl 5.14.2 using perlbrew and had no problems I didn't cause myself. The PostgreSQL RPM