On Tue, 15 Nov 2016, Adrian Klaver wrote:
To add to my previous post. If you do decide to follow the pg_upgrade
procedure in the README do a pg_dump of the 9.5 data just before you do
pg_ugrade and store it away in a safe place. The first time through a new
process does not always end well:)
A
On Wed, 16 Nov 2016, Alban Hertroys wrote:
pg_upgrade migrates your databases from your old (9.5) cluster to the
new (9.6) one. Initdb doesn't do that.
Alban,
That's what I assumed to be the case.
If your 9.6 database does indeed contain your databases, then something
must have done the p
On 16 November 2016 at 16:33, Rich Shepard wrote:
> On Tue, 15 Nov 2016, Rich Shepard wrote:
> If 9.6.1 is currently running after running initdb, and I can access my
> databases, what does pg_upgrade do that's necessary?
pg_upgrade migrates your databases from your old (9.5) cluster to the
ne
On Tue, 15 Nov 2016, Rich Shepard wrote:
$ /usr/bin/pg_ctl --version
pg_ctl (PostgreSQL) 9.6.1
ls -al /usr/bin/pg_ctl
lrwxrwxrwx 1 root root 32 Nov 15 14:16 /usr/bin/pg_ctl ->
../lib/postgresql/9.6/bin/pg_ctl*
To increase my understanding I want to resolve an apparent discrepancy in
version
On Tue, 15 Nov 2016, Adrian Klaver wrote:
So what do you get with
/usr/bin/pg_ctl --version
Interesting:
$ /usr/bin/pg_ctl --version
pg_ctl (PostgreSQL) 9.6.1
and given John's suggestion:
ls -al /usr/bin/pg_ctl
ls -al /usr/bin/pg_ctl
lrwxrwxrwx 1 root root 32 Nov 15 14:16 /usr/bin/pg_ct
On 11/15/2016 05:18 PM, Rich Shepard wrote:
On Tue, 15 Nov 2016, Adrian Klaver wrote:
Rich is using Slackware and I am pretty sure it marches to a different
drummer.
Adrian,
And a different band. Pat likes MariaDB which replaced MySQL so
PostgreSQL
is not part of the base distribution. But
On 11/15/2016 05:18 PM, Rich Shepard wrote:
On Tue, 15 Nov 2016, Adrian Klaver wrote:
Rich is using Slackware and I am pretty sure it marches to a different
drummer.
Adrian,
And a different band. Pat likes MariaDB which replaced MySQL so
PostgreSQL
is not part of the base distribution. But
On 11/15/2016 05:06 PM, Rich Shepard wrote:
On Tue, 15 Nov 2016, Adrian Klaver wrote:
Assuming the bindirs are in your $PATH:
aklaver@panda:~> whereis -f pg_ctl
Adrian,
In my case:
$ whereis -f pg_ctl
pg_ctl: /bin/pg_ctl /usr/bin/pg_ctl /usr/X11R6/bin/pg_ctl
/usr/bin/X11/pg_ctl /usr/X11/
On Tue, 15 Nov 2016, Adrian Klaver wrote:
Rich is using Slackware and I am pretty sure it marches to a different
drummer.
Adrian,
And a different band. Pat likes MariaDB which replaced MySQL so PostgreSQL
is not part of the base distribution. But, SlackBuilds.org provides a build
script tha
On 11/15/2016 05:01 PM, John R Pierce wrote:
On 11/15/2016 4:55 PM, Adrian Klaver wrote:
where do I look for the two bindirs?
Assuming the bindirs are in your $PATH:
aklaver@panda:~> whereis -f pg_ctl
pg_ctl: /usr/local/pgsql/bin/pg_ctl /usr/local/pgsql94/bin/pg_ctl
Even if only one is the $
On Tue, 15 Nov 2016, Adrian Klaver wrote:
Assuming the bindirs are in your $PATH:
aklaver@panda:~> whereis -f pg_ctl
Adrian,
In my case:
$ whereis -f pg_ctl
pg_ctl: /bin/pg_ctl /usr/bin/pg_ctl /usr/X11R6/bin/pg_ctl
/usr/bin/X11/pg_ctl /usr/X11/bin/pg_ctl /usr/man/man1/pg_ctl.1
/usr/man/ma
On 11/15/2016 4:55 PM, Adrian Klaver wrote:
where do I look for the two bindirs?
Assuming the bindirs are in your $PATH:
aklaver@panda:~> whereis -f pg_ctl
pg_ctl: /usr/local/pgsql/bin/pg_ctl /usr/local/pgsql94/bin/pg_ctl
Even if only one is the $PATH:
aklaver@panda:~> whereis -f pg_ctl
pg_c
On Tue, 15 Nov 2016, John R Pierce wrote:
9.5 is considered a major version, 9.5.4 is a minor.this will change
when 10 is released, from 10 on, major versions will be 10, 11, 12, ...
John,
So the upgrade from 9.5.4 to 9.6.1 is as I assumed: major.
based on the data paths you gave, I'm
On 11/15/2016 02:37 PM, Rich Shepard wrote:
All my previous version upgrades were performed by running pg_dumpall in
the older version followed by running 'pgsql -f ...' to install the dumped
.sql file, usually because the upgrade jumped several versions. Now I'd
like
to try the available postg
On 11/15/2016 2:37 PM, Rich Shepard wrote:
All my previous version upgrades were performed by running
pg_dumpall in
the older version followed by running 'pgsql -f ...' to install the
dumped
.sql file, usually because the upgrade jumped several versions. Now
I'd like
to try the available pos
All my previous version upgrades were performed by running pg_dumpall in
the older version followed by running 'pgsql -f ...' to install the dumped
.sql file, usually because the upgrade jumped several versions. Now I'd like
to try the available postgres commands.
The older version is install
16 matches
Mail list logo