Hi, when I run `docker/sdk demo-data` (i want just reset db and service and import fresh everything)

giovanni.piemontese

Hi, when I run docker/sdk demo-data (i want just reset db and service and import fresh everything) sdk run loadDemoData with at end of this function `

execSpryker "vendor/bin/install -r docker -s init-storages-per-region -s ${demoDataSection}"

But i get following error:

Dropping all database tables.
 Error happened during dropping database tables.                                                                                                                                                         
 SQLSTATE[42501]: Insufficient privilege: 7 ERROR:  must be a superuser to terminate superuser process
CONTEXT:  SQL statement "SELECT pg_terminate_backend(pid)
                        FROM pg_stat_activity
                        WHERE pg_stat_activity.datname = current_database() AND pid <> pg_backend_pid()"
PL/pgSQL function inline_code_block line 6 at PERFORM

In CommandLineExecutable.php line 107:

  Aborted install...  

Anyone idea why so? sdk up works in the case IF_NOT_PERFORMED!

giovanni.piemontese

sdk reset works.. sdk demo not due permission for db

sprymiker

Do you connect to the database from host machine?

giovanni.piemontese

yes... without problems..

sprymiker

With what credentials? spryker or root

giovanni.piemontese

root

sprymiker

That’s the point. You have rootopened connection and script that works with spryker cannot close it to remove all the tables during demo data import.

giovanni.piemontese

Ok.... now it s me clear...

sprymiker

So this problem won’t have place if you connect only with spryker user

giovanni.piemontese

thank u very much..

giovanni.piemontese

yes.. of course

sprymiker

np