adrianboimvaser/postgresql-maven-plugin

A Maven plugin for doing things with a PostgreSQL database, like starting, stopping, initializing a DB, etc.

postgresql-maven-plugin's Issues

Let select port

Drop Database

More of a question than an bug, but does the init db, drop any existing databases? Is there a drop db equivalent. I see there is a create database goal.

Not able to start Embedded PostgreSQL database

@adrianboimvaser
I am trying to start the DB but no luck.
Please Help!

The same error happens in the integration test within this project:

[INFO] --- maven-invoker-plugin:1.7:integration-test (integration-test) @ postgresql-maven-plugin ---
[INFO] Building: start-stop/pom.xml
[INFO] ..FAILED (99.5 s)

Basically the start-stop IT does not start the DB properly and the exception is thrown:

[INFO] Starting PostgreSQL
[ERROR]
java.lang.InterruptedException: timeout reached (60s)

I do not see much in the build.log only the stacktrace:

java.lang.InterruptedException: timeout reached (60s)
at com.github.adrianboimvaser.postgresql.plugin.StartMojo.started(StartMojo.java:83)
at com.github.adrianboimvaser.postgresql.plugin.StartMojo.doExecute(StartMojo.java:53)
at com.github.adrianboimvaser.postgresql.plugin.PgctlMojo.execute(PgctlMojo.java:26)
at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:207)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)
at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)
at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106)
at org.apache.maven.cli.MavenCli.execute(MavenCli.java:863)
at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:199)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)
at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
at org.codehaus.classworlds.Launcher.main(Launcher.java:47)

Starting PostgreSQL hangs on a busy port

When starting PG on a busy port, starting process hangs definitely.

 <plugin>
                <groupId>com.github.adrianboimvaser</groupId>
                <artifactId>postgresql-maven-plugin</artifactId>
                <version>0.11</version>
                <configuration>
                    <pgsqlHome>${project.build.directory}/pgsql</pgsqlHome>
                    <dataDir>${project.build.directory}/data</dataDir>
                    <port>${postgresql.port}</port>
                    <skip>false</skip>
                    <databaseName>${database.name}</databaseName>
                    <username>${postgresql.user}</username>
                    <password>${postgresql.password}</password>
                    <encoding>UTF8</encoding>
                </configuration>
                <executions>
                    <execution>
                        <id>initdb-postgresql</id>
                        <phase>pre-integration-test</phase>
                        <goals>
                            <goal>initdb</goal>
                        </goals>
                    </execution>
                    <execution>
                        <id>start-postgresql</id>
                        <phase>pre-integration-test</phase>
                        <goals>
                            <goal>start</goal>
                        </goals>
                        <configuration>
                            <parameters>
                                <log_statement>all</log_statement>
                                <log_destination>csvlog</log_destination>
                                <logging_collector>on</logging_collector>
                                <log_directory>pg_log</log_directory>
                            </parameters>
                        </configuration>
                    </execution>
                    <execution>
                        <id>create-conciliator-db</id>
                        <phase>pre-integration-test</phase>
                        <goals>
                            <goal>createdb</goal>
                        </goals>
                    </execution>
                    <execution>
                        <id>createdb-rules-store-db</id>
                        <phase>pre-integration-test</phase>
                        <goals>
                            <goal>createdb</goal>
                        </goals>
                        <configuration>
                            <username>${postgresql.user}</username>
                            <databaseName>rules</databaseName>
                        </configuration>
                    </execution>
               </executions>
</plugin>

[INFO]
[INFO] --- postgresql-maven-plugin:0.11:start (start-postgresql) @ rules-engine-testing ---
[INFO] Starting PostgreSQL
^C

Publish maven generated site on gh-pages branch

Make start goal monitor the process in a separate thread...

... and stop PostgreSQL if an InterruptedException is caught.

Maven Central?

Do you have it published in Maven Central somewhere?

release 0.2 to Maven Central

Would be great if you can release version 0.2 to Maven Central

run sql script pre-integration-test

is there a way to run an sql script on pre-integration-test? or on post-integration-test?

InitDB encoding

Hello,

Can you please add encoding for initdb.

Thanks

Make start goal force pg_ctl to run in English

Add <skip/> parameter to all goals.