[dspace-tech] Re: pgcrypto extension is installed in PostgreSQL 14.7, but reports as not installed on this DATABASE
Hi Zikrul,
Try this in the sequence you see it.
1) su - postgres
2) psql
3) \password
4) drop database dspace;
5) drop user dspace;
6) drop extension if exists pgcrypto;
7) drop schema extensions;
8) \q
9) createuser --username=postgres --no-superuser --pwprompt dspace
10) createdb --username=postgres --owner=dspace --encoding=UNICODE dspace
11) psql --username=postgres dspace
12) CREATE SCHEMA extensions;
13) CREATE EXTENSION pgcrypto SCHEMA extensions;
14) GRANT USAGE ON SCHEMA extensions TO dspace;
15) SELECT set_config('search_path',current_setting('search_path') ||
',extensions',false) WHERE current_setting('search_path') !~
'(^|,)extensions(,|$)';
16) SHOW search_path;
17) ALTER DATABASE dspace SET search_path FROM CURRENT;
18) \q
19) exit
20) systemctl enable postgresql
21) systemctl restart postgresql
22) psql -U dspace -W -h localhost
23) \conninfo
24) \q
25) exit
### Conitune DSpace installation
Hope it help
Mo.
On Tuesday, March 28, 2023 at 4:06:10 PM UTC+3 Zikrul wrote:
> Hi Mohammad,
>
> Many thanks for your prompt reply. I have tried $ant fresh_install after
> each fix for pgcrypto you have mentioned but issue did not resolved. Any
> other idea please?
>
> test_database:
> [java] 2023-03-28 13:59:20,868 WARN
> org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by
> name or id=database. Will try to look up bean by type next.
>
> [java]
> org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean
> named 'database' available
> [java] at
> org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:872)
>
> ~[spring-beans-5.3.20.jar:5.3.20]
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1344)
>
> ~[spring-beans-5.3.20.jar:5.3.20]
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:309)
>
> ~[spring-beans-5.3.20.jar:5.3.20]
> [java] at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213)
>
> ~[spring-beans-5.3.20.jar:5.3.20]
> [java] at
> org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1160)
>
> ~[spring-context-5.3.20.jar:5.3.20]
> [java] at
> org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426)
>
> [dspace-services-7.5.jar:7.5]
> [java] at
> org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:34)
>
> [dspace-api-7.5.jar:7.5]
> [java] at
> org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125)
> [dspace-api-7.5.jar:7.5]
> [java] at
> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98)
> [dspace-api-7.5.jar:7.5]
> [java] 2023-03-28 13:59:21,165 WARN
> org.flywaydb.core.internal.database.base.Database @ Flyway upgrade
> recommended: PostgreSQL 15.2 is newer than this version of Flyway and
> support has not been tested. The latest supported version of PostgreSQL is
> 14.
>
> [java]
> [java] Attempting to connect to database
> [java] Connected successfully!
> [java]
> [java] Database Type: postgres
> [java] Database URL: jdbc:postgresql://localhost:5432/dspace
>
> Regards
> Zikrul
> On Tuesday, 28 March 2023 at 13:22:38 UTC+1 Mohammad S. AlMutairi wrote:
>
>> Hi Zikrul,
>>
>> All you need to fix it without having to recreate the pgcrypto extension
>> using the second method is by adding it into the search path by one of
>> these commands ( *psql --username=postgres dspace -c 'ALTER ROLE dspace
>> IN DATABASE dspace SET search_path = "$user",public,extensions,pgcrypto;'*
>> ) or ( *psql --username=postgres dspace -c 'ALTER DATABASE dspace SET
>> search_path = "$user",public,extensions,pgcrypto;'* ) and then double
>> check it to see if it's included by ( *psql --username=postgres dspace
>> -c 'SHOW search_path;'* ).
>>
>> NB: Creating the pgcrypto extension using the second method will save you
>> from creating it again if you later for any reason have to clean your
>> database. Please read *Alternative method: How to enable pgcrypto via a
>> separate database schema.) *found in here
>> https://wiki.lyrasis.org/display/DSDOC7x/Installing+DSpace#InstallingDSpace-PostgreSQL11.x,12.xor13.x(withpgcryptoinstalled).
>>
>> Carefully.
>>
>> Hope it help
>>
>> Mo.
>>
>>
>>
>> On Tuesday, March 28, 2023 at 2:51:55 PM UTC+3 Zikrul wrote:
>>
>>> Hi,
>>> I also have the same problem as Baskar while running $ant fresh_install.
>>> Regarding Mohammad's reply to recreate pgcrypto, I did create successfully
>>> before. If I try to recreate now then it says below as already it is there.
>>>
>>> bash-4.4$ psql --username=postgres dspace -c "CREATE EXTENSION pgcrypto;"
>>> ERROR:
[dspace-tech] Re: pgcrypto extension is installed in PostgreSQL 14.7, but reports as not installed on this DATABASE
Hi Mohammad, Many thanks for your prompt reply. I have tried $ant fresh_install after each fix for pgcrypto you have mentioned but issue did not resolved. Any other idea please? test_database: [java] 2023-03-28 13:59:20,868 WARN org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by name or id=database. Will try to look up bean by type next. [java] org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'database' available [java] at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:872) ~[spring-beans-5.3.20.jar:5.3.20] [java] at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1344) ~[spring-beans-5.3.20.jar:5.3.20] [java] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:309) ~[spring-beans-5.3.20.jar:5.3.20] [java] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213) ~[spring-beans-5.3.20.jar:5.3.20] [java] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1160) ~[spring-context-5.3.20.jar:5.3.20] [java] at org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426) [dspace-services-7.5.jar:7.5] [java] at org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:34) [dspace-api-7.5.jar:7.5] [java] at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125) [dspace-api-7.5.jar:7.5] [java] at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) [dspace-api-7.5.jar:7.5] [java] 2023-03-28 13:59:21,165 WARN org.flywaydb.core.internal.database.base.Database @ Flyway upgrade recommended: PostgreSQL 15.2 is newer than this version of Flyway and support has not been tested. The latest supported version of PostgreSQL is 14. [java] [java] Attempting to connect to database [java] Connected successfully! [java] [java] Database Type: postgres [java] Database URL: jdbc:postgresql://localhost:5432/dspace Regards Zikrul On Tuesday, 28 March 2023 at 13:22:38 UTC+1 Mohammad S. AlMutairi wrote: > Hi Zikrul, > > All you need to fix it without having to recreate the pgcrypto extension > using the second method is by adding it into the search path by one of > these commands ( *psql --username=postgres dspace -c 'ALTER ROLE dspace > IN DATABASE dspace SET search_path = "$user",public,extensions,pgcrypto;'* > ) or ( *psql --username=postgres dspace -c 'ALTER DATABASE dspace SET > search_path = "$user",public,extensions,pgcrypto;'* ) and then double > check it to see if it's included by ( *psql --username=postgres dspace > -c 'SHOW search_path;'* ). > > NB: Creating the pgcrypto extension using the second method will save you > from creating it again if you later for any reason have to clean your > database. Please read *Alternative method: How to enable pgcrypto via a > separate database schema.) *found in here > https://wiki.lyrasis.org/display/DSDOC7x/Installing+DSpace#InstallingDSpace-PostgreSQL11.x,12.xor13.x(withpgcryptoinstalled). > > Carefully. > > Hope it help > > Mo. > > > > On Tuesday, March 28, 2023 at 2:51:55 PM UTC+3 Zikrul wrote: > >> Hi, >> I also have the same problem as Baskar while running $ant fresh_install. >> Regarding Mohammad's reply to recreate pgcrypto, I did create successfully >> before. If I try to recreate now then it says below as already it is there. >> >> bash-4.4$ psql --username=postgres dspace -c "CREATE EXTENSION pgcrypto;" >> ERROR: extension "pgcrypto" already exists >> >> I am not sure Baskar, if you had a chance to fix it or found any solution >> of it. Please share if possible or can someone help please? >> I have checked there is no table >> >> Following is my current setup environment: >> === >> OS: Red Hat Enterprise Linux 8.7 >> OpenJDK: v17.0.6 >> Apache: v2.4.37 >> Tomcat: v10.0.27 >> Maven: v3.8.6 >> Ant: 1.10.12 >> Postgres: v15 >> DSpace: v7.5 (Failing/Warning during ant fresh_install. Does not create >> any tables after ant finishes) >> >> ant fresh_install full output: >> -- >> $ ant fresh_install >> ... >> init_configs: >> >> [java] 2023-02-21 11:11:45,527 WARN >> org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by >> name or id=database. Will try to look up bean by type next. >> >> [java] >> org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean >> named 'database' available >> [java] at >>
[dspace-tech] Re: pgcrypto extension is installed in PostgreSQL 14.7, but reports as not installed on this DATABASE
Hi Zikrul, All you need to fix it without having to recreate the pgcrypto extension using the second method is by adding it into the search path by one of these commands ( *psql --username=postgres dspace -c 'ALTER ROLE dspace IN DATABASE dspace SET search_path = "$user",public,extensions,pgcrypto;'* ) or ( *psql --username=postgres dspace -c 'ALTER DATABASE dspace SET search_path = "$user",public,extensions,pgcrypto;'* ) and then double check it to see if it's included by ( *psql --username=postgres dspace -c 'SHOW search_path;'* ). NB: Creating the pgcrypto extension using the second method will save you from creating it again if you later for any reason have to clean your database. Please read *Alternative method: How to enable pgcrypto via a separate database schema.) *found in here https://wiki.lyrasis.org/display/DSDOC7x/Installing+DSpace#InstallingDSpace-PostgreSQL11.x,12.xor13.x(withpgcryptoinstalled). Carefully. Hope it help Mo. On Tuesday, March 28, 2023 at 2:51:55 PM UTC+3 Zikrul wrote: > Hi, > I also have the same problem as Baskar while running $ant fresh_install. > Regarding Mohammad's reply to recreate pgcrypto, I did create successfully > before. If I try to recreate now then it says below as already it is there. > > bash-4.4$ psql --username=postgres dspace -c "CREATE EXTENSION pgcrypto;" > ERROR: extension "pgcrypto" already exists > > I am not sure Baskar, if you had a chance to fix it or found any solution > of it. Please share if possible or can someone help please? > I have checked there is no table > > Following is my current setup environment: > === > OS: Red Hat Enterprise Linux 8.7 > OpenJDK: v17.0.6 > Apache: v2.4.37 > Tomcat: v10.0.27 > Maven: v3.8.6 > Ant: 1.10.12 > Postgres: v15 > DSpace: v7.5 (Failing/Warning during ant fresh_install. Does not create > any tables after ant finishes) > > ant fresh_install full output: > -- > $ ant fresh_install > ... > init_configs: > > [java] 2023-02-21 11:11:45,527 WARN > org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by > name or id=database. Will try to look up bean by type next. > > [java] > org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean > named 'database' available > [java] at > org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:872) > > ~[spring-beans-5.3.20.jar:5.3.20] > [java] at > org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1344) > > ~[spring-beans-5.3.20.jar:5.3.20] > [java] at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:309) > > ~[spring-beans-5.3.20.jar:5.3.20] > [java] at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213) > > ~[spring-beans-5.3.20.jar:5.3.20] > [java] at > org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1160) > > ~[spring-context-5.3.20.jar:5.3.20] > [java] at > org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426) > > [dspace-services-7.5.jar:7.5] > [java] at > org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:34) > > [dspace-api-7.5.jar:7.5] > [java] at > org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125) > [dspace-api-7.5.jar:7.5] > [java] at > org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) > [dspace-api-7.5.jar:7.5] > [java] 2023-02-21 11:11:45,820 WARN > org.flywaydb.core.internal.database.base.Database @ Flyway upgrade > recommended: PostgreSQL 15.1 is newer than this version of Flyway and > support has not been tested. The latest supported version of PostgreSQL is > 14. > > [java] > [java] Attempting to connect to database > [java] Connected successfully! > [java] > [java] Database Type: postgres > [java] Database URL: jdbc:postgresql://localhost:5432/dspace > [java] Database Schema: public > [java] Database Username: dspace > [java] Database Software: PostgreSQL version 15.1 > > [java] Database Driver: PostgreSQL JDBC Driver version 42.4.3 > [java] PostgreSQL 'pgcrypto' extension installed/up-to-date? true > (version=1.3) > [java] FlywayDB Version: 8.4.4 > > install_code: > > [echo] > [echo] > > [echo] The DSpace code has been installed. > [echo] > > [echo] > > fresh_install: > > copy_webapps: >.. > build_webapps_wars: > > check_spiders: > >
[dspace-tech] Re: pgcrypto extension is installed in PostgreSQL 14.7, but reports as not installed on this DATABASE
Hi, I also have the same problem as Baskar while running $ant fresh_install. Regarding Mohammad's reply to recreate pgcrypto, I did create successfully before. If I try to recreate now then it says below as already it is there. bash-4.4$ psql --username=postgres dspace -c "CREATE EXTENSION pgcrypto;" ERROR: extension "pgcrypto" already exists I am not sure Baskar, if you had a chance to fix it or found any solution of it. Please share if possible or can someone help please? I have checked there is no table Following is my current setup environment: === OS: Red Hat Enterprise Linux 8.7 OpenJDK: v17.0.6 Apache: v2.4.37 Tomcat: v10.0.27 Maven: v3.8.6 Ant: 1.10.12 Postgres: v15 DSpace: v7.5 (Failing/Warning during ant fresh_install. Does not create any tables after ant finishes) ant fresh_install full output: -- $ ant fresh_install ... init_configs: [java] 2023-02-21 11:11:45,527 WARN org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by name or id=database. Will try to look up bean by type next. [java] org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'database' available [java] at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:872) ~[spring-beans-5.3.20.jar:5.3.20] [java] at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1344) ~[spring-beans-5.3.20.jar:5.3.20] [java] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:309) ~[spring-beans-5.3.20.jar:5.3.20] [java] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213) ~[spring-beans-5.3.20.jar:5.3.20] [java] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1160) ~[spring-context-5.3.20.jar:5.3.20] [java] at org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426) [dspace-services-7.5.jar:7.5] [java] at org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:34) [dspace-api-7.5.jar:7.5] [java] at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125) [dspace-api-7.5.jar:7.5] [java] at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) [dspace-api-7.5.jar:7.5] [java] 2023-02-21 11:11:45,820 WARN org.flywaydb.core.internal.database.base.Database @ Flyway upgrade recommended: PostgreSQL 15.1 is newer than this version of Flyway and support has not been tested. The latest supported version of PostgreSQL is 14. [java] [java] Attempting to connect to database [java] Connected successfully! [java] [java] Database Type: postgres [java] Database URL: jdbc:postgresql://localhost:5432/dspace [java] Database Schema: public [java] Database Username: dspace [java] Database Software: PostgreSQL version 15.1 [java] Database Driver: PostgreSQL JDBC Driver version 42.4.3 [java] PostgreSQL 'pgcrypto' extension installed/up-to-date? true (version=1.3) [java] FlywayDB Version: 8.4.4 install_code: [echo] [echo] [echo] The DSpace code has been installed. [echo] [echo] fresh_install: copy_webapps: .. build_webapps_wars: check_spiders: init_spiders: [echo] [echo] [echo] The DSpace code has been installed. [echo] [echo] To complete installation, you should do the following: [echo] [echo] * Setup your Web servlet container (e.g. Tomcat) to look for your .. [echo] [echo] BUILD SUCCESSFUL Total time: 7 seconds NO Tables CREATED in DSpace during ant fresh_install: ### $ psql dspace psql (15.1) Type "help" for help. dspace=> \dt Did not find any relations. On Friday, 24 March 2023 at 11:56:52 UTC Mohammad S. AlMutairi wrote: > Hi, > > I think it can not be found because it's not included into the search > path. See this old post for hints on how to fix it: > https://groups.google.com/g/dspace-tech/c/Hy8lxiaxH4I/m/8yrHFW5lBgAJ or > better if you recreate the pgcrypto extention using the ( *Alternative > method: How to enable pgcrypto via a separate database schema.) *found in > here > https://wiki.lyrasis.org/display/DSDOC7x/Installing+DSpace#InstallingDSpace-PostgreSQL11.x,12.xor13.x(withpgcryptoinstalled) > . > > >
[dspace-tech] Re: pgcrypto extension is installed in PostgreSQL 14.7, but reports as not installed on this DATABASE
Hi, I think it can not be found because it's not included into the search path. See this old post for hints on how to fix it: https://groups.google.com/g/dspace-tech/c/Hy8lxiaxH4I/m/8yrHFW5lBgAJ or better if you recreate the pgcrypto extention using the ( *Alternative method: How to enable pgcrypto via a separate database schema.) *found in here https://wiki.lyrasis.org/display/DSDOC7x/Installing+DSpace#InstallingDSpace-PostgreSQL11.x,12.xor13.x(withpgcryptoinstalled). Mo. On Friday, March 24, 2023 at 2:25:47 PM UTC+3 Baskar Selvaraj wrote: > Hi, > > OS: Ubuntu 22.04.2 > PostgreSQL: 14.7 > DSpace: 7.5 > pgcrypto extension: 1.3 > > init_configs: > [copy] Copying 222 files to /home/dspace/config >[delete] Deleting directory > /dspace-7.5/dspace/target/dspace-installer/config-temp > [copy] Copying 1 file to /home/dspace/config > > test_database: > [java] 2023-03-24 06:55:56,440 WARN > org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by > name or id=database. Will try to look up bean by type next. > [java] > org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean > named 'database' available > [java] at > org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:872) > > ~[spring-beans-5.3.20.jar:5.3.20] > [java] at > org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1344) > > ~[spring-beans-5.3.20.jar:5.3.20] > [java] at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:309) > > ~[spring-beans-5.3.20.jar:5.3.20] > [java] at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213) > > ~[spring-beans-5.3.20.jar:5.3.20] > [java] at > org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1160) > > ~[spring-context-5.3.20.jar:5.3.20] > [java] at > org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426) > > [dspace-services-7.5.jar:7.5] > [java] at > org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:34) > > [dspace-api-7.5.jar:7.5] > [java] at > org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125) > [dspace-api-7.5.jar:7.5] > [java] at > org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) > [dspace-api-7.5.jar:7.5] > [java] > [java] Attempting to connect to database > [java] Connected successfully! > [java] > [java] Database Type: postgres > [java] Database URL: jdbc:postgresql://localhost:5432/dspace > [java] Database Schema: public > [java] Database Username: dspace > [java] Database Software: PostgreSQL version 14.7 (Ubuntu > 14.7-0ubuntu0.22.04.1) > [java] Database Driver: PostgreSQL JDBC Driver version 42.4.3 > [java] PostgreSQL 'pgcrypto' extension installed/up-to-date? false > (not installed) > [java] FlywayDB Version: 8.4.4 > [java] > [java] WARNING: Required PostgreSQL 'pgcrypto' extension is NOT > INSTALLED on this database. > [java] > [java] ** DSpace REQUIRES PostgreSQL >= 9.4 AND pgcrypto extension >= > 1.1 ** > [java] > [java] To install it, please connect to your DSpace database as a > 'superuser' and manually run the following command: > [java] > [java] CREATE EXTENSION pgcrypto; > [java] > > BUILD FAILED > /dspace-7.5/dspace/target/dspace-installer/build.xml:770: Java returned: 1 > > Total time: 9 seconds > > - > > pgcrypto is installed and enabled > > psql (14.7 (Ubuntu 14.7-0ubuntu0.22.04.1)) > Type "help" for help. > > postgres=# select * from pg_available_extensions; > name| default_version | installed_version | > comment > > +-+---+ > > intagg | 1.1 | | integer > aggregator and enumerator (obsolete) > tsm_system_rows| 1.0 | | TABLESAMPLE > method which accepts number of rows as a limit > refint | 1.0 | | functions for > implementing referential integrity (obsolete) > pgcrypto | 1.3 | 1.3 | cryptographic > functions > file_fdw | 1.0 | | foreign-data > wrapper for flat file access > hstore | 1.8 | | data type for > storing sets of (key, value) pairs > pg_stat_statements | 1.9 | | track planning > and
