asyncee / fias2pgsql Goto Github PK

View Code? Open in Web Editor NEW

63.0 63.0 21.0 30 KB

Скрипты для импорта ФИАС в Postgresql

Python 15.63% PLpgSQL 50.01% Shell 34.36%

fias2pgsql's People

Contributors

Stargazers

Watchers

Forkers

alexander-efremov kitoss12 xlazex serpentehok cn324 q210 wrussia northv npaul rbarinov sharigar keroosha sibdigital godfreyd fialkovod interest1ngcat dmitr2ish u-company densonrus

fias2pgsql's Issues

Релиз 1.0

Я предлагаю следующее в связи с тем, что у меня есть правки относительно путей внутри скриптов:

Синхронизировать develop и master
Я делаю pull request с моими правками
Мы делаем релиз 1.0.0, так как я не могу оценить: есть ли сейчас обратная совместимость или нет
Я также предлагаю делать все изменения в develop, а релизы связывать с веткой master

Сделать универсальный import_table.sh

Сделать универсальный import_table.sh, в который параметром можно было бы передать имя любой таблицы для загрузки.

ALTER TABLE addrobj ADD CONSTRAINT addrobj_pkey PRIMARY KEY(aoguid);

ALTER TABLE addrobj ADD CONSTRAINT addrobj_pkey PRIMARY KEY(aoguid); такой запрос в принципе не может быть выполнен потому что в поле aoguid встречаются дублирующие записи.

Какие все таки ключи правильные??

Ошибки в update_schema.sql

Version - psql (10.5 (Debian 10.5-2.pgdg90+1))

Являются ли эти ошибки фатальными? Текущая реализация должна уметь искать по адрусу ФИАС? Например запрос по ФИАС 3e8d1508-25c9-4100-9608-fa1a085137ab выдает пустой результат

UPDATE 54395
psql:update_schema.sql:45: ERROR:  invalid input syntax for type date: ""
СТРОКА 1: UPDATE addrobj SET enddate = NULL WHERE enddate = '';
                                                            ^
psql:update_schema.sql:48: ERROR:  invalid input syntax for type date: ""
СТРОКА 1: UPDATE addrobj SET startdate = NULL WHERE startdate = '';
                                                                ^
UPDATE 247962
BEGIN

Весь лог сценария index.sh.

PGPASSWORD=fias PGPORT=5433 PGHOST=127.0.0.1 PGUSER=fias bash index.sh "fias"
_______________________НАЧИНАЮ ИМПОРТ ИЗ ФАЙЛОВ__________________
++++++++++++++++++ HELLO, DB = fias
++++++++++++++++++ SOCRBASE TABLE CREATED
BEGIN
SET
NOTICE:  table "socrbase" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ CHECKING ADDROBJ FILES
BEGIN
SET
NOTICE:  table "addrobj" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ INITIAL ADDROBJ TABLE CREATED
BEGIN
SET
NOTICE:  table "addrob02" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB02 CREATED
++++++++++++++++++ INSERT ADDROB02 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob03" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB03 CREATED
++++++++++++++++++ INSERT ADDROB03 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob04" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB04 CREATED
++++++++++++++++++ INSERT ADDROB04 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob05" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB05 CREATED
++++++++++++++++++ INSERT ADDROB05 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob06" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB06 CREATED
++++++++++++++++++ INSERT ADDROB06 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob07" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB07 CREATED
++++++++++++++++++ INSERT ADDROB07 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob08" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB08 CREATED
++++++++++++++++++ INSERT ADDROB08 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob09" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB09 CREATED
++++++++++++++++++ INSERT ADDROB09 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob10" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB10 CREATED
++++++++++++++++++ INSERT ADDROB10 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob11" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB11 CREATED
++++++++++++++++++ INSERT ADDROB11 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob12" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB12 CREATED
++++++++++++++++++ INSERT ADDROB12 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob13" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB13 CREATED
++++++++++++++++++ INSERT ADDROB13 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob14" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB14 CREATED
++++++++++++++++++ INSERT ADDROB14 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob15" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB15 CREATED
++++++++++++++++++ INSERT ADDROB15 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob16" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB16 CREATED
++++++++++++++++++ INSERT ADDROB16 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob17" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB17 CREATED
++++++++++++++++++ INSERT ADDROB17 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob18" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB18 CREATED
++++++++++++++++++ INSERT ADDROB18 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob19" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB19 CREATED
++++++++++++++++++ INSERT ADDROB19 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob20" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB20 CREATED
++++++++++++++++++ INSERT ADDROB20 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob21" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB21 CREATED
++++++++++++++++++ INSERT ADDROB21 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob22" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB22 CREATED
++++++++++++++++++ INSERT ADDROB22 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob23" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB23 CREATED
++++++++++++++++++ INSERT ADDROB23 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob24" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB24 CREATED
++++++++++++++++++ INSERT ADDROB24 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob25" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB25 CREATED
++++++++++++++++++ INSERT ADDROB25 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob26" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB26 CREATED
++++++++++++++++++ INSERT ADDROB26 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob27" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB27 CREATED
++++++++++++++++++ INSERT ADDROB27 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob28" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB28 CREATED
++++++++++++++++++ INSERT ADDROB28 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob29" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB29 CREATED
++++++++++++++++++ INSERT ADDROB29 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob30" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB30 CREATED
++++++++++++++++++ INSERT ADDROB30 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob31" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB31 CREATED
++++++++++++++++++ INSERT ADDROB31 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob32" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB32 CREATED
++++++++++++++++++ INSERT ADDROB32 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob33" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB33 CREATED
++++++++++++++++++ INSERT ADDROB33 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob34" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB34 CREATED
++++++++++++++++++ INSERT ADDROB34 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob35" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB35 CREATED
++++++++++++++++++ INSERT ADDROB35 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob36" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB36 CREATED
++++++++++++++++++ INSERT ADDROB36 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob37" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB37 CREATED
++++++++++++++++++ INSERT ADDROB37 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob38" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB38 CREATED
++++++++++++++++++ INSERT ADDROB38 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob39" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB39 CREATED
++++++++++++++++++ INSERT ADDROB39 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob40" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB40 CREATED
++++++++++++++++++ INSERT ADDROB40 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob41" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB41 CREATED
++++++++++++++++++ INSERT ADDROB41 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob42" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB42 CREATED
++++++++++++++++++ INSERT ADDROB42 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob43" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB43 CREATED
++++++++++++++++++ INSERT ADDROB43 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob44" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB44 CREATED
++++++++++++++++++ INSERT ADDROB44 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob45" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB45 CREATED
++++++++++++++++++ INSERT ADDROB45 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob46" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB46 CREATED
++++++++++++++++++ INSERT ADDROB46 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob47" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB47 CREATED
++++++++++++++++++ INSERT ADDROB47 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob48" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB48 CREATED
++++++++++++++++++ INSERT ADDROB48 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob49" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB49 CREATED
++++++++++++++++++ INSERT ADDROB49 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob50" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB50 CREATED
++++++++++++++++++ INSERT ADDROB50 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob51" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB51 CREATED
++++++++++++++++++ INSERT ADDROB51 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob52" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB52 CREATED
++++++++++++++++++ INSERT ADDROB52 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob53" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB53 CREATED
++++++++++++++++++ INSERT ADDROB53 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob54" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB54 CREATED
++++++++++++++++++ INSERT ADDROB54 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob55" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB55 CREATED
++++++++++++++++++ INSERT ADDROB55 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob56" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB56 CREATED
++++++++++++++++++ INSERT ADDROB56 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob57" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB57 CREATED
++++++++++++++++++ INSERT ADDROB57 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob58" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB58 CREATED
++++++++++++++++++ INSERT ADDROB58 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob59" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB59 CREATED
++++++++++++++++++ INSERT ADDROB59 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob60" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB60 CREATED
++++++++++++++++++ INSERT ADDROB60 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob61" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB61 CREATED
++++++++++++++++++ INSERT ADDROB61 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob62" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB62 CREATED
++++++++++++++++++ INSERT ADDROB62 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob63" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB63 CREATED
++++++++++++++++++ INSERT ADDROB63 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob64" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB64 CREATED
++++++++++++++++++ INSERT ADDROB64 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob65" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB65 CREATED
++++++++++++++++++ INSERT ADDROB65 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob66" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB66 CREATED
++++++++++++++++++ INSERT ADDROB66 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob67" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB67 CREATED
++++++++++++++++++ INSERT ADDROB67 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob68" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB68 CREATED
++++++++++++++++++ INSERT ADDROB68 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob69" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB69 CREATED
++++++++++++++++++ INSERT ADDROB69 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob70" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB70 CREATED
++++++++++++++++++ INSERT ADDROB70 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob71" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB71 CREATED
++++++++++++++++++ INSERT ADDROB71 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob72" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB72 CREATED
++++++++++++++++++ INSERT ADDROB72 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob73" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB73 CREATED
++++++++++++++++++ INSERT ADDROB73 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob74" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB74 CREATED
++++++++++++++++++ INSERT ADDROB74 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob75" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB75 CREATED
++++++++++++++++++ INSERT ADDROB75 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob76" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB76 CREATED
++++++++++++++++++ INSERT ADDROB76 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob77" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB77 CREATED
++++++++++++++++++ INSERT ADDROB77 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob78" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB78 CREATED
++++++++++++++++++ INSERT ADDROB78 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob79" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB79 CREATED
++++++++++++++++++ INSERT ADDROB79 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob83" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB83 CREATED
++++++++++++++++++ INSERT ADDROB83 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob86" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB86 CREATED
++++++++++++++++++ INSERT ADDROB86 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob87" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB87 CREATED
++++++++++++++++++ INSERT ADDROB87 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob89" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB89 CREATED
++++++++++++++++++ INSERT ADDROB89 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob91" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB91 CREATED
++++++++++++++++++ INSERT ADDROB91 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob92" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB92 CREATED
++++++++++++++++++ INSERT ADDROB92 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob99" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB99 CREATED
++++++++++++++++++ INSERT ADDROB99 DATA INTO ADDROBJ
DROP TABLE
SKIPPING ADDROBJ
SKIPPING ADDROBJ
_______________________НАЧИНАЮ ОБНОВЛЕНИЕ СХЕМЫ__________________
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 408
ALTER TABLE
COMMIT
UPDATE 1405645
UPDATE 1413399
UPDATE 2139783
UPDATE 2128000
UPDATE 11819
UPDATE 11829
UPDATE 2530681
UPDATE 105
UPDATE 44840
UPDATE 54395
psql:update_schema.sql:45: ERROR:  invalid input syntax for type date: ""
СТРОКА 1: UPDATE addrobj SET enddate = NULL WHERE enddate = '';
                                                            ^
psql:update_schema.sql:48: ERROR:  invalid input syntax for type date: ""
СТРОКА 1: UPDATE addrobj SET startdate = NULL WHERE startdate = '';
                                                                ^
UPDATE 247962
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
_______________________НАЧИНАЮ СОЗДАНИЕ ИНДЕКСОВ_________________
psql:indexes.sql:2: ERROR:  extension "pg_trgm" already exists
DELETE 2467296
ALTER TABLE
CREATE INDEX
CREATE INDEX
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
_______________________ _________ГОТОВО________ _________________
[root@142223 fias2pgsql]#

Относительный путь в import.sh, хотя в параметрах используется полный

fias2pgsql/import.sh

Line 11 in 51394e3

mv .$PATH_TO_DBF_FILES/ADDROB01.DBF $PATH_TO_DBF_FILES/ADDROBJ.DBF

Скорость работы и размер бд

Добрый день! подскажите сколько времени занимает полный парсинг с 0 и сколько места занимает конечная бд. также интересует наличие партиций в таблицах. Спасибо

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.