database - Exporting a Java project that uses PostgreSQL -


i couldn't find answer question. how can export java project makes use of postgresql database?

i want use same database on computer. need export database project? how can done?

what should connection url be, database accessible on computer?

i'm using jdbc, , i'm on windows.

thanks in advance.

edit: wouldn't need dynamically retrieve username , password on other computer, instead of using specific username , password have on computer in postgresql?

it depends on want achieve.

shared database between hosts

do want application on both computers use same database, changes made 1 seen on other? if so, need configure each copy of application connect same database instance on 1 of machines. done changing jdbc url. you'll need configure postgresql on machine that'll database server allows connections other hosts, ensure can talk each other on tcp/ip, etc.

fresh db on each host

do want each install have separate instance of database, changes made on 1 have no effect on other, , each instance starts out blank, empty database (or 1 static contents lookup tables)? if so, should define database using sql scripts, have application run sql scripts when first installed on machine. if you've defined database hand far, can use pg_dump create sql script can use basis this, advise tools liquibase schema management instead.

"fork" current state

do want each instance of application on machine have independent database, changes made on 1 have no effect on other instances on other machines, starting state of install in database on other host? if so, need dump , reload database alongside application, using pg_dump -fc , pg_restore. can automate within application / build system using tools processbuilder, or manually.

there's no generic, canned way this. it'll require define application deployment procedure, maybe produce installer, etc.


-

Comments

Post a Comment

Popular posts from this blog

c# - Binding a comma separated list to a List<int> in asp.net web api -

the default binder in web api expecst http://url.com/webapi/report/?pageids=3243&pageids=2365 to bind public ihttpactionresult report(list<int> pageids){ // exciting webapi code} i wish bind http://url.com/webapi/report/?pageids=3243,2365 as running out of space in url get . i have created class public class commaseparatedmodelbinder : system.web.http.modelbinding.imodelbinder { public bool bindmodel(httpactioncontext actioncontext, modelbindingcontext bindingcontext) { //binding in here } } and registered in webapiconfig.cs var provider = new simplemodelbinderprovider( typeof(list<int>), new commaseparatedmodelbinder()); config.services.insert(typeof(modelbinderprovider), 0, provider); i have altered method signature use model binder so public ihttpactionresult report( [modelbinder] list<int> pageids){ // exciting webapi code} however break point in binder not being
Read more

Delphi 7 and decode UTF-8 base64 -

in delphi 7, have widestring encoded base64(that received web service widestring result) : pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg== when decoded it, result not utf-8: <?xml version="1.0"?> <string>طھط³طھ</string> but when decoded base64decode.org, result true : <?xml version="1.0"?> <string>تست</string> i have use encddecd unit decodestring function. the problem have using decodestring . function, in delphi 7, treats decoded binary data being ansi encoded. , problem text utf-8 encoded. to continue encddecd unit have couple of options. can switch decodestream . instance, code produce utf-8 encoded text file data: {$apptype console} uses classes, encddecd; const data = 'pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg=='; var input: tstringstream; output: tfilestream; begin input := tstringstream.create(data); try output := tfilestream.
Read more

html - Is there any way to exclude a single element from the style? (Bootstrap) -

so, have img logo, overlaid on div styled background-image: url("...") , , both elements inside 2 div classes .to-color , .to-overlay respectively, black transparent overlay. is there way exclude logo style given these 2 classes? here's jsfiddle example: link html , css example: - html - <div class="to-color"> <div class="to-overlay"> <div class="respo"> <div class="row"> <div class="col-xs-4 col-xs-offset-4 text-center"> <img src="http://ansonalex.com/wp-content/uploads/2011/06/google-logo-768x260.png" alt="..." class="img-responsive"> </div> </div> </div> </div> </div> - css - .to-color { background-color: #000; } .to-overlay { opacity : 0.5; } .respo { background-image: url("https://source.unsplash.com/category/objects/1600x900"); background-position: center center;
Read more