cancel
Showing results for 
Search instead for 
Did you mean: 
Create a Post

migrate export in bash script

Running into this, when running 'migrate export ....' in a bash script.   It works fine directly from command the command line.

RE: R80.00 GA  manager

I attached the output from the migration log.

I'm going to try adding the shared library to the PATH first.     Maybe it's a postgreSQL HBA issue for a local user, not sure yet.

Adding PGDIR, PATH and libraries worked and the backup worked fine.

Now, on the test restore, I'm getting psql.bin: FATAL: password authentication failed for user "postgres"

Labels (1)
Tags (1)
0 Kudos
10 Replies
Employee+
Employee+

Re: migrate export in bash script

Hi,

We will check the issue and let you know.

0 Kudos
Employee+
Employee+

Re: migrate export in bash script

Please verify that you are running your process under root permissions.

You are not able to run psql_client without being root.

0 Kudos

Re: migrate export in bash script

Thanks.

This is a R80.00 GA to R80.00 GA migrate export/import.  Yes, I'm running in expert mode.   I also verified the same issue happens taking my script out of the equation.

This issue can be replicated from the $FWDIR/bin/upgrade_tools/migrate binary, both migrates used (on the source and destination R80 -build 101 boxes is 10870840 bytes (the same version).

#NOTE:  After rebuilding the box I was importing too, the issue dis-appeared, restored to a clean box worked.

0 Kudos

Re: migrate export in bash script

This was using take 29 for source and destination, I see take 63 is out now.

0 Kudos
Employee+
Employee+

Re: migrate export in bash script

We are trying to investigate the psql_client issue and we need to know more information about what was done on the environment:

1. Did you modify in any way $FWDIR/conf?

2. Can you list the exact libs/files you added/modified?

3. What do you mean by "test restore"?

0 Kudos

Re: migrate export in bash script

1. No

2. 0 libs/files modified

3. migrate export / migrate import

0 Kudos

Re: migrate export in bash script

I also tried to migrate export/import with a different migrate utility that is 127

Still got the same psql.bin: FATAL: password authentication failed for user "postgres"

This is going from R80.00 take 29 to R80.00 take 29.

My next test will be to go from R80.00 take 29 to R80.00 take 63.

0 Kudos

Re: migrate export in bash script

Has anybody tried migrate export/import with R80.   I get the same issue with postgres password authentication going from:

take 29 to jumbo 63

take 29 to take 29

jumbo 63 to jumbo 63

How can you update the postgres user, allow the postgres user?

Is this just a HBA issue ?

I'm not planning on moving to R80 until 'migrate' works .

0 Kudos

Re: migrate export in bash script

I have a case open with TAC and this is a known issue.   They are working on it.  I'll update this discussion once resolved.

0 Kudos

Re: migrate export in bash script

I was able to successfully import to a restore box today on T113/29 jumbo 63 to T113/29 (no jumbo) as instructed per TAC and it worked!   I was then able to connect to the newly restored manager on R80 T113/29 with the newer R80 T113/29 jumbo take 63 smart console client to the the older R80 T113/29 system.   So, good news I didn't get the postgres user error.

0 Kudos