Vjylku

Math-accent symbol over parentheses enclosing accented symbol (amsmath)

Why does standard notation not preserve intervals (visually)

Why isn't the Mueller report being released completely and unredacted?

Would a grinding machine be a simple and workable propulsion system for an interplanetary spacecraft?

Need help understanding a power circuit (caps and diodes)

WOW air has ceased operation, can I get my tickets refunded?

What steps are necessary to read a Modern SSD in Medieval Europe?

Is there always a complete, orthogonal set of unitary matrices?

Why do remote US companies require working in the US?

0 rank tensor vs 1D vector

No sign flipping while figuring out the emf of voltaic cell?

How to avoid supervisors with prejudiced views?

Why is quantifier elimination desirable for a given theory?

The exact meaning of 'Mom made me a sandwich'

Bartok - Syncopation (1): Meaning of notes in between Grand Staff

How to install OpenCV on Raspbian Stretch?

Method for adding error messages to a dictionary given a key

Is French Guiana a (hard) EU border?

How to get from Geneva Airport to Metabief?

Writing differences on a blackboard

How did people program for Consoles with multiple CPUs?

Does soap repel water?

Which one is the true statement?

Why, when going from special to general relativity, do we just replace partial derivatives with covariant derivatives?

Enterprise geodatabase on PostgreSQL backup and restore

1

windows 7, PostgreSQL 9.4/ArcSDE/PostGIS backend database that I am transferring to another computer.

My backup command is as follows. host 5433

pg_dumpall -h localhost -p 5433 -U postgres -c -f "file.backup" 

backups up all nice and everything.

when I go to restore it on windows 10, PostgreSQL 9.4, port 5433 I run

psql -h localhost -p 5433 -U postgres -f file.backup

so everything restores okay. All tables, schemas, logins are good. I can connect with QGIS and everything works fine.

Problem

When I go to add an ArcGIS database connection I get this error

UPDATE

I uninstalled postgres on the new computer reinstalled 9.5,
ran psql -h localhost -p 5432 -U postgres -f file.backup on port 5432 and in the CMD I found 1 error it should while it is running the restore

psql:R:/Data/LUCZ_2017/blah.backup:12531010: ERROR:  relation "gdb_items" does not exist

whats going on here!

Based on Evan Carroll's suggestion I ran

C:Program FilesPostgreSQL9.5bin>psql duS+

Password:

psql: FATAL:  password authentication failed for user "rizagha"

the CMD wouldn't let me enter my password, I pressed enter and received the above error

arcgis-desktop postgresql enterprise-geodatabase

share|improve this question

edited Jan 9 '18 at 18:38

ziggy

asked Jan 9 '18 at 14:39

ziggyziggy

1,99421136

bumped to the homepage by Community♦ 3 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  5433 is not a valid instance. The proper syntax is hostname,5433. Please remember to include the entire error message as text in the body of your question.
  
  – Vince
  Jan 9 '18 at 15:02
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  5433 works as a proper instance for me on my old computer. and even with localhost,5433 I get the exact same error
  
  – ziggy
  Jan 9 '18 at 15:06
  
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Did you change the database name? Does the table "lucz.sde.gdb_release" exist?
  
  – Vince
  Jan 9 '18 at 15:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I did not change the database name, and the table "lucz.sde.gdb_release" does not even exists in my old working database
  
  – ziggy
  Jan 9 '18 at 15:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are you sure you're restoring to port 5433 on Windows, 5432 is the default? Also you're connecting with user:conflict and restoring from user:postgres can you connect with user:postgres?
  
  – Evan Carroll
  Jan 9 '18 at 16:09
  
  
  

  
  
  
  

 | 
show 7 more comments

1

windows 7, PostgreSQL 9.4/ArcSDE/PostGIS backend database that I am transferring to another computer.

My backup command is as follows. host 5433

pg_dumpall -h localhost -p 5433 -U postgres -c -f "file.backup" 

backups up all nice and everything.

when I go to restore it on windows 10, PostgreSQL 9.4, port 5433 I run

psql -h localhost -p 5433 -U postgres -f file.backup

so everything restores okay. All tables, schemas, logins are good. I can connect with QGIS and everything works fine.

Problem

When I go to add an ArcGIS database connection I get this error

UPDATE

I uninstalled postgres on the new computer reinstalled 9.5,
ran psql -h localhost -p 5432 -U postgres -f file.backup on port 5432 and in the CMD I found 1 error it should while it is running the restore

psql:R:/Data/LUCZ_2017/blah.backup:12531010: ERROR:  relation "gdb_items" does not exist

whats going on here!

Based on Evan Carroll's suggestion I ran

C:Program FilesPostgreSQL9.5bin>psql duS+

Password:

psql: FATAL:  password authentication failed for user "rizagha"

the CMD wouldn't let me enter my password, I pressed enter and received the above error

arcgis-desktop postgresql enterprise-geodatabase

share|improve this question

edited Jan 9 '18 at 18:38

ziggy

asked Jan 9 '18 at 14:39

ziggyziggy

1,99421136

bumped to the homepage by Community♦ 3 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  5433 is not a valid instance. The proper syntax is hostname,5433. Please remember to include the entire error message as text in the body of your question.
  
  – Vince
  Jan 9 '18 at 15:02
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  5433 works as a proper instance for me on my old computer. and even with localhost,5433 I get the exact same error
  
  – ziggy
  Jan 9 '18 at 15:06
  
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Did you change the database name? Does the table "lucz.sde.gdb_release" exist?
  
  – Vince
  Jan 9 '18 at 15:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I did not change the database name, and the table "lucz.sde.gdb_release" does not even exists in my old working database
  
  – ziggy
  Jan 9 '18 at 15:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are you sure you're restoring to port 5433 on Windows, 5432 is the default? Also you're connecting with user:conflict and restoring from user:postgres can you connect with user:postgres?
  
  – Evan Carroll
  Jan 9 '18 at 16:09
  
  
  

  
  
  
  

 | 
show 7 more comments

windows 7, PostgreSQL 9.4/ArcSDE/PostGIS backend database that I am transferring to another computer.

My backup command is as follows. host 5433

pg_dumpall -h localhost -p 5433 -U postgres -c -f "file.backup" 

backups up all nice and everything.

when I go to restore it on windows 10, PostgreSQL 9.4, port 5433 I run

psql -h localhost -p 5433 -U postgres -f file.backup

so everything restores okay. All tables, schemas, logins are good. I can connect with QGIS and everything works fine.

Problem

When I go to add an ArcGIS database connection I get this error

UPDATE

I uninstalled postgres on the new computer reinstalled 9.5,
ran psql -h localhost -p 5432 -U postgres -f file.backup on port 5432 and in the CMD I found 1 error it should while it is running the restore

psql:R:/Data/LUCZ_2017/blah.backup:12531010: ERROR:  relation "gdb_items" does not exist

whats going on here!

Based on Evan Carroll's suggestion I ran

C:Program FilesPostgreSQL9.5bin>psql duS+

Password:

psql: FATAL:  password authentication failed for user "rizagha"

the CMD wouldn't let me enter my password, I pressed enter and received the above error

arcgis-desktop postgresql enterprise-geodatabase

share|improve this question

edited Jan 9 '18 at 18:38

ziggy

asked Jan 9 '18 at 14:39

ziggyziggy

1,99421136

pg_dumpall -h localhost -p 5433 -U postgres -c -f "file.backup" 

psql -h localhost -p 5433 -U postgres -f file.backup

psql:R:/Data/LUCZ_2017/blah.backup:12531010: ERROR:  relation "gdb_items" does not exist

C:Program FilesPostgreSQL9.5bin>psql duS+

Password:

psql: FATAL:  password authentication failed for user "rizagha"

share|improve this question

edited Jan 9 '18 at 18:38

ziggy

asked Jan 9 '18 at 14:39

ziggyziggy

1,99421136

share|improve this question

edited Jan 9 '18 at 18:38

ziggy

asked Jan 9 '18 at 14:39

ziggyziggy

1,99421136

asked Jan 9 '18 at 14:39

ziggyziggy

1,99421136

asked Jan 9 '18 at 14:39

ziggyziggy

1,99421136

1 Answer
1

active

oldest

votes

0

Can you connect with the conflict user using psql?

I'm guessing strongly that you don't have your pg_hba.conf configured properly. Check out the difference between the old install and the new install. It's not backed up with restore/dump. I assume you're missing something like this

host lucz conflict all md5

You need to at lest enable host to connect with md5.

See this guide on "PostgreSQL is installed on a Windows server on ESRI" for more information.

If you can connect

You may need the ESRI schema, sde which provides the GDB_Release table. ESRI provide either

1. A python script and a DLL


2. The Create Enterprise Geodatabase tool

You'll have to run one of those to turn your PostgreSQL into a geodatabase.

share|improve this answer

edited Jan 10 '18 at 0:52

Vince

14.8k32849

answered Jan 9 '18 at 16:28

Evan CarrollEvan Carroll

4,9821341

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I cannot connect with the conflict user using psql
  
  – ziggy
  Jan 9 '18 at 16:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm contemplating uninstalling postgresql on this computer, reinstalling a newer version and trying to restore this
  
  – ziggy
  Jan 9 '18 at 16:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  this did nothing host conflict all all md5 and conflict is a schema and login role not a database for me
  
  – ziggy
  Jan 9 '18 at 16:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @ziggy sorry I typeoed that pg_hba wrong, try that. and paste the result of duS+ as requested previously.
  
  – Evan Carroll
  Jan 9 '18 at 16:36
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  look at my update, once it fully restores I will go through your suggestions once more
  
  – ziggy
  Jan 9 '18 at 17:30
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f267398%2fenterprise-geodatabase-on-postgresql-backup-and-restore%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

Can you connect with the conflict user using psql?

I'm guessing strongly that you don't have your pg_hba.conf configured properly. Check out the difference between the old install and the new install. It's not backed up with restore/dump. I assume you're missing something like this

host lucz conflict all md5

You need to at lest enable host to connect with md5.

See this guide on "PostgreSQL is installed on a Windows server on ESRI" for more information.

If you can connect

You may need the ESRI schema, sde which provides the GDB_Release table. ESRI provide either

1. A python script and a DLL


2. The Create Enterprise Geodatabase tool

You'll have to run one of those to turn your PostgreSQL into a geodatabase.

share|improve this answer

edited Jan 10 '18 at 0:52

Vince

14.8k32849

answered Jan 9 '18 at 16:28

Evan CarrollEvan Carroll

4,9821341

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I cannot connect with the conflict user using psql
  
  – ziggy
  Jan 9 '18 at 16:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm contemplating uninstalling postgresql on this computer, reinstalling a newer version and trying to restore this
  
  – ziggy
  Jan 9 '18 at 16:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  this did nothing host conflict all all md5 and conflict is a schema and login role not a database for me
  
  – ziggy
  Jan 9 '18 at 16:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @ziggy sorry I typeoed that pg_hba wrong, try that. and paste the result of duS+ as requested previously.
  
  – Evan Carroll
  Jan 9 '18 at 16:36
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  look at my update, once it fully restores I will go through your suggestions once more
  
  – ziggy
  Jan 9 '18 at 17:30
  

  
  
  
  

add a comment | 

0

Can you connect with the conflict user using psql?

I'm guessing strongly that you don't have your pg_hba.conf configured properly. Check out the difference between the old install and the new install. It's not backed up with restore/dump. I assume you're missing something like this

host lucz conflict all md5

You need to at lest enable host to connect with md5.

See this guide on "PostgreSQL is installed on a Windows server on ESRI" for more information.

If you can connect

You may need the ESRI schema, sde which provides the GDB_Release table. ESRI provide either

1. A python script and a DLL


2. The Create Enterprise Geodatabase tool

You'll have to run one of those to turn your PostgreSQL into a geodatabase.

share|improve this answer

edited Jan 10 '18 at 0:52

Vince

14.8k32849

answered Jan 9 '18 at 16:28

Evan CarrollEvan Carroll

4,9821341

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I cannot connect with the conflict user using psql
  
  – ziggy
  Jan 9 '18 at 16:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm contemplating uninstalling postgresql on this computer, reinstalling a newer version and trying to restore this
  
  – ziggy
  Jan 9 '18 at 16:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  this did nothing host conflict all all md5 and conflict is a schema and login role not a database for me
  
  – ziggy
  Jan 9 '18 at 16:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @ziggy sorry I typeoed that pg_hba wrong, try that. and paste the result of duS+ as requested previously.
  
  – Evan Carroll
  Jan 9 '18 at 16:36
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  look at my update, once it fully restores I will go through your suggestions once more
  
  – ziggy
  Jan 9 '18 at 17:30
  

  
  
  
  

add a comment | 

Can you connect with the conflict user using psql?

I'm guessing strongly that you don't have your pg_hba.conf configured properly. Check out the difference between the old install and the new install. It's not backed up with restore/dump. I assume you're missing something like this

host lucz conflict all md5

You need to at lest enable host to connect with md5.

See this guide on "PostgreSQL is installed on a Windows server on ESRI" for more information.

If you can connect

You may need the ESRI schema, sde which provides the GDB_Release table. ESRI provide either

1. A python script and a DLL


2. The Create Enterprise Geodatabase tool

You'll have to run one of those to turn your PostgreSQL into a geodatabase.

share|improve this answer

edited Jan 10 '18 at 0:52

Vince

14.8k32849

answered Jan 9 '18 at 16:28

Evan CarrollEvan Carroll

4,9821341

host lucz conflict all md5

share|improve this answer

edited Jan 10 '18 at 0:52

Vince

14.8k32849

answered Jan 9 '18 at 16:28

Evan CarrollEvan Carroll

4,9821341

edited Jan 10 '18 at 0:52

Vince

14.8k32849

edited Jan 10 '18 at 0:52

Vince

14.8k32849

answered Jan 9 '18 at 16:28

Evan CarrollEvan Carroll

4,9821341

answered Jan 9 '18 at 16:28

Evan CarrollEvan Carroll

4,9821341