guedes / pgvm Goto Github PK

View Code? Open in Web Editor NEW

120.0 120.0 22.0 512 KB

PostgreSQL Version Manager

Shell 100.00%

postgresql rvm version

pgvm's People

Contributors

Stargazers

Watchers

pgvm's Issues

psql: could not connect to server: Connection refused

Hi, I am running pgvm successfully, byt when I installed it on my other mac, I can't run psql:

psql: could not connect to server: Connection refused
    Is the server running on host "localhost" (::1) and accepting
    TCP/IP connections on port 5432?
could not connect to server: Connection refused
    Is the server running on host "localhost" (127.0.0.1) and accepting
    TCP/IP connections on port 5432?

installing the contrib package complains about connection too

I have done:

pgvm install 9.3.5
pgvm use 9.3.5
pgvm cluster create master
pgvm cluster start master

And I also tried restart. which psql returns what seems correct path:
/Users/michal/.pgvm/environments/current/bin/psql

Can anyone point me the right direction?

Fail set locale in travis test

The farm machines in travis-ci.org is not have en.US as a locale/encoding type. The suggestion tttest using UTF-8 as default .

change `use` action to allow X.Y args instead X.Y.Z for version

ensure that pgvm list doesn't throws error while there is a pgvm install running

add `cluster` options to create more than one $PGDATA for the same version

This allow you to have many data directories for the same PostgreSQL Installed Version

create Creates a new cluster (PGDATA)
remove Removes a cluster
rename Renames a cluster
list List all cluster

import Import a cluster from tarball
export Export a cluster to tarball

bug: Error message to install with Git

fike@alderoon:~/.pgvm$ pgvm install master
/home/fike/.pgvm/include/helpers: line 165: cd: /home/fike/.pgvm/src/postgresql-clone: Arquivo ou diretório não encontrado

Running a cluster on port 5432

So I was running an instance of pgvm on a cluster managed on localhost (OSX pg version 9.3.10) and I wasn't able to connect to that cluster on port 5432. Other ports seem to be fine when I modify the postgresql.conf file in the data directory. I think this may be an issue with pgvm or how the clusters get setup. It says that the cluster is running and it's running on the correct port with a PID but nothing (pgvm console or other applications) can connect to it.

detect 'curl' or 'wget' to use as a downloader tool

CHECKSUM of 'postgresql-.tar.gz' has failed

Getting this error when I try to use pgvm for postgres 9 or 9.5
advice?

Can't build contrib 9.5.3: make[1]: Nothing to be done for `all'.

Again, not sure if thats a pgvm problem or not, but the contribs don't build on my mac :(

~/.pgvm/src/postgresql-9.3.5/contrib ((detached from v0.2.1))$ make
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C adminpack all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C auth_delay all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C auto_explain all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C btree_gin all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C btree_gist all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C chkpass all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C citext all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C cube all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C dblink all
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C ../../src/interfaces/libpq all
make[2]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C dict_int all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C dict_xsyn all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C dummy_seclabel all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C earthdistance all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C file_fdw all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C fuzzystrmatch all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C hstore all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C intagg all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C intarray all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C isn all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C lo all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C ltree all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C oid2name all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pageinspect all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C passwordcheck all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pg_archivecleanup all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pg_buffercache all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pg_freespacemap all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pg_standby all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pg_stat_statements all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pg_test_fsync all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pg_test_timing all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pg_trgm all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pg_upgrade all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pg_upgrade_support all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pgbench all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pgcrypto all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pgrowlocks all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pgstattuple all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C pg_xlogdump all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C postgres_fdw all
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C ../../src/interfaces/libpq all
make[2]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C seg all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C spi all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C tablefunc all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C tcn all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C test_parser all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C tsearch2 all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C unaccent all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C vacuumlo all
make[1]: Nothing to be done for `all'.
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C worker_spi all
make[1]: Nothing to be done for `all'.

the 'install' action accepts '--contribs' and '--extensions'

It would be nice if I could choose at install step which contribs/extensions will be installed.

We could, also, create an action to do that integrated with pgxn-client

pgvm install 9 do not found the last 9 version

~ (1.9.3-p327) 
# pgvm install 9
downloading 'http://ftp.postgresql.org/pub/source/v/postgresql-.tar.gz', please be patient... done.
checking 'postgresql-.tar.gz' integrity... 
~ (1.9.3-p327) 
# pgvm list
Please, install a PostgreSQL Version!


~ (1.9.3-p327) 
#

Do you need some information to trace the problem? :)

Compiling 9.3.5: FATAL: role "ubuntu" does not exist

Not sure if this is an issue with pgvm, any ideas?

configuring PostgreSQL Version: 9.5.3 ... Configured with: --prefix=/Applications/Xcode.app/Contents/Developer/usr --with-gxx-include-dir=/usr/include/c++/4.2.1
done.
compiling ... FATAL:  role "ubuntu" does not exist

Then install then finishes and seems to work.

create a lib to handle generic things

Today pgvm is all in bash, but talking with @fabriziomello, @lhcezar and @fike, we think that this could be split into more layers. The actual internal file structure is stable and this could be a good signal to create a plumbing lib.

Still maintained?

Is it still maintain? @guedes

How to start cluster from /etc/rc.local file?

This code don't work from /etc/rc.local:

sudo -u user111 /home/user111/.pgvm/bin/pgvm cluster start user111

How can I auto start cluster after system reboot?

How to install extensions, such as hstore?

Hi, how do I install extensions, such as hstore?

Test if install parameter is empty

Actually, install command don't test if your parameters is empty. When it tries to install, it happen this error:

fike@alderoon:~$ pgvm install

downloading 'http://ftp.postgresql.org/pub/source/v/postgresql-.tar.gz', please be patient... done.
checking 'postgresql-.tar.gz' integrity... ERRO: CHECKSUM of 'postgresql-.tar.gz' has failed! Aborting!
 fike@alderoon:~$

install action should installs from repositories

It will be interesting to a postgres developer if pgvm allow installation from a branch or a branch plus a patch or a list of patches

can not install on ubuntu under regular user

bblive@Ubuntu-1404-trusty-64-minimal:~$ curl -s -L https://raw.github.com/guedes/pgvm/master/bin/pgvm-self-install | bash
PostgreSQL version manager's installer

wait while the installer fetches pgvm's files ...sorry, pgvm could not be installed

add an `uninstall` action

This could be implemented in some ways, I can figure out two:

keeps the downloaded tarball by default, unless explicit required by an option
removes everything related to an installation by default, but could keeps tarballs if an options was passed

What do you think @fike ?

add a `current` action

This action shows current postgres version. It could be use with datasets to show which dataset is currently in use.

psql: sslmode value "require" invalid when SSL support is not compiled in

Hi, I get this error message when I try to pull postgresql from Heroku.

Stack overflow says thats a problem with my local psql, that I need to recompile it with SSL support.

How can I achieve this with pgvm?

guedes / pgvm Goto Github PK

pgvm's People

Contributors

Stargazers

Watchers

Forkers

pgvm's Issues

Recommend Projects

Recommend Topics

Recommend Org