New answers tagged

0

For a fool-proof strategy you can try proxmox, so you virtualize your dedicated server and can take advantage of kvm virtualization if planning to use Windows os, or lxc for recent linux distro. Then you can easily snaphot each VM into external ftp/nfs + some 'ol good file level backup (attic backup, acronis, rsync, rsnapshot, rdiff backup, bacula, and so ...


0

Short answer for AWS services that load DBF : NO Longer answer : RDS services doesn't support DBF file types. One issues of DBF is, there is no standard. A dbf can be from ANY database engine, format is varied. If you want CORRECT answer, you must specify what DB engine it is, and not all db engine will recognise them. If you have an apps or DB engine that ...


0

I can just say that I was lucky that by coincidence I bought a D2700 and a P822 + P830 as this solves all negative aspects on my HP DL385P Gen8 with 8 Bays. I will add 1 Cage so I end up with 16 Bays and the P830 can handle it: The HP Smart Array P830 allows you to connect a total of 16 drives spanning two separate drive cages. ...


1

Thanks everyone, I just made a change in /var/lib/pgsql/9.4/data/pg_hba.conf with : local all all ldap ldapserver=ldap.server ldapport=389 ldaptls=0 ldapprefix="uid=" ldapsuffix=",ou=People,dc=domain,dc=com" And the authentication works!


1

Read the Friendly Manual: http://www.postgresql.org/docs/9.5/static/auth-methods.html You probably want to use https://github.com/larskanis/pg-ldap-sync to sync your LDAP users and groups to PostgreSQL


1

Agreed -- db mirroring would be highly unlikely in this situation since it works best if it's persistent and would need manual intervention every time you turned your desktop system on. Snapshot Replication is the only realistic option in the replication world, and there's no benefit gained over using a simple database backup and restore or AWS snapshot.


3

Point 2, can be addressed by using AWS RDS to back up data for you. Otherwise, you manually need to create a snapshot of your EC2 instance but this involved a tiny bit of downtime and will cost money to store on S3. Point 1, just restore the database Either way, you want a high level of functionality that you don't want to pay for, so our options for ...


0

My first pass on solving this would be to use a forward error recovery pattern. If the app detects it is running the staging environment, allow failed lookups to query the production environment for the record, and then recreate that state in the test environment, update your staging db with the new record id, and return the newly created record.


2

Execution plans: OBVIOUSLY. As does restarting the server - these are kept in memory and generated on demand. Which also means you never collected them over the years. Unless you have a never patched system which would be a much bigger problem. Statistics: no, those are actually objects in the database, so they transfer. Here you also did NOT collect them ...


3

how any vendor can reliably ensure storage throughput (which is critical for DW performance) without creating a configuration bottleneck? By hiring really smart people to design their back-end systems. Why do we still talk about 'shared nothing' when every single cloud supplier uses virtualization and therefore shared storage? Shared ...


0

Notice the documentation's definition of default_pool_size How many server connections to allow per user/database pair. So if the default config is a pool size of 20, out of a 100 connections total, this implies 5 distinct user/database pairs will have to each max out their pool size before they reach the overall limit. Conversely, if for example ...



Top 50 recent answers are included