Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit8269e4a

Browse files
committed
Integrated pgpro_upgrade system into the sources
1 parenta24a89c commit8269e4a

File tree

6 files changed

+130
-1
lines changed

6 files changed

+130
-1
lines changed

‎src/Makefile‎

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -25,7 +25,8 @@ SUBDIRS = \
2525
bin\
2626
pl\
2727
makefiles\
28-
test/regress
28+
test/regress\
29+
pgpro-upgrade
2930

3031
# There are too many interdependencies between the subdirectories, so
3132
# don't attempt parallel make here.

‎src/pgpro-upgrade/Makefile‎

Lines changed: 24 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,24 @@
1+
#-------------------------------------------------------------------------
2+
#
3+
# Makefile for src/pgpro-upgrade (Postgres Pro specific upgrade scripts)
4+
#
5+
# Copyright (c) 2016, Postgres Professional
6+
#
7+
# src/pgpro-upgrade/Makefile
8+
#
9+
#-------------------------------------------------------------------------
10+
11+
subdir = src/pgpro-upgrade
12+
top_builddir = ../..
13+
include$(top_builddir)/src/Makefile.global
14+
srcdir=$(top_srcdir)/$(subdir)
15+
16+
all:
17+
true
18+
19+
install: installdirs
20+
$(INSTALL_PROGRAM)$(srcdir)/pgpro_upgrade'$(DESTDIR)$(bindir)/pgpro_upgrade'
21+
$(INSTALL_DATA)$(srcdir)/*.sql$(srcdir)/*.test'$(DESTDIR)$(datadir)/pgpro-upgrade'
22+
installdirs:
23+
$(MKDIR_P)'$(DESTDIR)$(bindir)'
24+
$(MKDIR_P)'$(DESTDIR)$(datadir)/pgpro-upgrade'

‎src/pgpro-upgrade/README‎

Lines changed: 46 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,46 @@
1+
PGPRO upgarde system
2+
====================
3+
4+
This directory contains pgpro_upgrade script which allows to add some
5+
features (such as internal functions) into catalog of existing database.
6+
7+
HOW TO INVOKE SCRIPT
8+
--------------------
9+
10+
Script is intended to be run from postinst script of installable
11+
packages. It should be invoked as database owning system user
12+
(typically, 'postgres').
13+
14+
Script expects that PGDATA environment variable points to database
15+
cluster to be upgraded.
16+
17+
Script is installed into postgresql bin directory, and user can run it
18+
manually, if he has database cluster, which are not known by package
19+
configuration file.
20+
21+
Script should be invoked when instance of PostgreSQL which is upgraded,
22+
is stopped.
23+
24+
Script doesn't depend of any authentication settings in pg_hba.conf,
25+
because it starts postgres in single-user mode to perform upgrades.
26+
27+
It is safe to invoke script multiple times, because it does check for
28+
features it is going to add.
29+
30+
HOW TO ADD NEW FEATURE
31+
----------------------
32+
33+
You need to add two sql files in this directory, if you want to add a
34+
feature.
35+
36+
Both files should have same base name and one — extension .test and
37+
other .sql
38+
39+
1. Script with .sql extension contains usial create commands which would
40+
create neccessary database object(s).
41+
42+
2. Script with .text extension should contain single select query,
43+
which returns single boolean value (i.e. one column and one row). This
44+
value should be 'f' if feature is not found in the database and should
45+
be installed, and 't' if it already exists.
46+

‎src/pgpro-upgrade/pgpro_upgrade‎

Lines changed: 56 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,56 @@
1+
#!/bin/sh
2+
# Utilities needed
3+
# 1. sh
4+
# 3. sed
5+
if [-z"$PGDATA" ];then
6+
echo"PGDATA environment variable is not set. Stop."1>&2
7+
exit 1
8+
fi
9+
PGBIN="`echo$0|sed's![^/\\]*$!!'`"
10+
11+
echo"$PGBIN"
12+
13+
case"$PGBIN"in
14+
*/bin/)
15+
PGSHARE="`echo$PGBIN|sed's!bin/$!share!'`"
16+
;;
17+
*) PGBIN=""
18+
PGSHARE=""
19+
;;
20+
esac
21+
22+
fordirin"$PGSHARE" /usr/pgsql-9.5/share /usr/share/postgresql/9.5 /usr/pgsql/9.5/share;do
23+
if [-d"$dir/pgpro-upgrade" ];then
24+
DIR="$dir/pgpro-upgrade"
25+
break
26+
fi
27+
done
28+
if [-z"$DIR" ];then
29+
echo"Cannot find feature scripts"1>&2
30+
exit 1
31+
fi
32+
BASELIST=`echo"select datname from pg_database;"|
33+
"${PGBIN}postgres" --single template0|
34+
sed -n's/^.*1: datname = "\([^"]*\)".*$/\1/p'`
35+
36+
if [-z"$BASELIST" ];then
37+
echo"Databases for upgrade not found"1>&2
38+
exit 1
39+
fi
40+
41+
echo"Upgrading databases$BASELIST"
42+
43+
#Search for upgrade scripts
44+
foriin"$DIR"/*.test;do
45+
create="`echo"$i"|sed's/\.test$/.sql/'`"
46+
found=`<"$i""${PGBIN}postgres" --single template0|
47+
sed -n's/^[ ]*1: [^ ]* = "\([ft]\)"[ ].*$/\1/p'`
48+
if ["$found"="f" ];then
49+
forbasein$BASELIST;do
50+
echo"Executing$create in$base"
51+
<"$create""${PGBIN}postgres" --single template0
52+
done
53+
fi
54+
done
55+
56+
Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
CREATEFUNCTIONpgpro_version() RETURNSTEXTAS'pgpro_version' LANGUAGE internal STRICT IMMUTABLE;
Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
select count(*) > 0 as pgpro_version from pg_proc where proname = 'pgpro_version';

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp