Tag Info

Hot answers tagged

12

It's an external module for Postgres. You should install the postgresql-contrib-8.4 (or your pg version) package via apt: apt-get install postgresql-contrib-8.4 Then you find the sql install file somewhere in the /usr/share/postgresql folder, and you'll need to run pgcryto.sql on the database. psql -d <database> -f ...


11

I had a similar isssue - Win7SP1, VS2010SP1, SQL2008R2, Powershell 2 etc. Every prerequisite was there and still SQL Server 2012 Developers edition did not install. Completing with the following error message for most of the features: Feature: Database Engine Services Status: Failed: see logs for details ...


11

Note that I'm working on Ubuntu 12.04, which uses postgresql 9.1. There, I needed to: sudo apt-get install postgresql-contrib And then in my database: postgres@ztrustee:~$ psql test psql (9.1.3) Type "help" for help. test=# CREATE EXTENSION pgcrypto; CREATE EXTENSION And now I can use pgcrypto functionality, gen_random_bytes(): test=# create table ...


10

If the correct auditing is turned on, and the security event log hasn't rolled over it'll be in there. Failing that it may not be. You could look at NTFS file permissions and ownership, and what accounts have sysadmin rights and possibly figure it out.


10

No, no and again no. One instance, one server, Always. The reasons have to do with the SQL Server memory manager and CPU scheduler architecture, it really works best if it has the whole box to itself and nothing else runs on the box. 'Partitioning' of resources (max server memory, affinity mask) solves some problems and introduces more. If you want to ...


9

Two solutions: Install oracle manually the first time. Then zip all ORACLE_HOME and for future installation simply do: Unzip oracle_home into the new home Run $ORACLE_HOME/bin/relink all Run ./runInstaller -silent -attachHome ORACLE_HOME="<Oracle_Home_Location>" ORACLE_HOME_NAME="<Oracle_Home_Name>" Other solution (not my preferred but ...


9

Well, if you have a legal copy of SQL Server, you should be able to install Management Studio from that media wherever you need to manage SQL Server from. That said, the Express version of Management Studio, since 2012 Service Pack 1, has been a fully functional product with absolutely no differences (except you can download it for free instead of finding ...


9

I knew I had faced this before and managed to figure it out, so I searched my drives and found a batch file I had written last time. For anyone else who experiences this issue, what you need to do is to run the server daemon with the --bootstrap parameters. Here is the script I used to dump all the databases out to an SQL file and re-import them (that is, ...


9

Integration Services is not "Instance aware". The rest (Analysis, Reporting, DB) are. Note that SSIS doesn't need to be instance aware either. The service itself is pretty pointless and doesn't need to running. You simply need the SQL Server common binaries installed to run packages. The service is for SQL Server Agent and SSMS to browse packages etc ...


8

This part is unusual: ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe/ This needs to be char-by-char identical every time. I see it ends with a slash here, which is non-standard, and I suspect that you've added it by mistake. Adding a slash will result in "ORACLE not available" in so-called bequeath sqlplus, I've just experimented on my system. Try again ...


7

This answer applies to modifying the PostgreSQL source code by applying a "diff" or "patch". It's not about installing minor version updates; to do that, just download and run the installer. To alter the PostgreSQL server its self or its procedural language runtimes, you will generally need to recompile PostgreSQL from scratch. On Windows that's a bit of ...


7

You can download and install SQL Server Management Studio using the links provided in: Scott Hanselman's website There are links to various SSMS versions (2012, 2014, for x86, x64), as well as links to various SQL-Server Express versions. By the way, you can also use the latest SSMS 2014 to manage your 2012 database.


7

As stated in BOL here: Cross-platform upgrade is not supported. You cannot upgrade a 32-bit instance of SQL Server to native 64-bit using SQL Server Setup. However, you can back up or detach databases from a 32-bit instance of SQL Server, and then restore or attach them to a new instance of SQL Server (64-bit) if the databases are not published in ...


7

Can I have this 32 bit installation use more memory using locked pages? In the past, my answer would have been (a heavily qualified) "yes". Using AWE (address windowing extensions) would enable up to 64GB memory. Unfortunately (from your point of view, perhaps) 32-bit AWE was removed from the database engine starting with SQL Server 2012. In previous ...


6

Locate the psql binary. (In a terminal, run locate psql | grep /bin, and make note of the path. (In my case, it's /opt/local/lib/postgresql90/bin/, as it was installed using MacPorts.) Then, edit the .bash_profile file in your home folder (e.g. mate -w ~/.bash_profile assuming you've textmate), and add the needed line so it's in your path, e.g.: export ...


6

Are you really trying to use Windows 8? No version of Oracle is supported on Windows 8 yet and, if history is any guide, I wouldn't expect any of them to work without patches that aren't available yet. Is Windows 8 even in public beta yet? I'd hate to try to take a class using an early beta operating system. Oracle 11.2 is supported on Windows 7 (which ...


6

Install the additional module btree_gist as is mentioned in the manual at the location you linked to: You can use the btree_gist extension to define exclusion constraints on plain scalar data types, which can then be combined with range exclusions for maximum flexibility. For example, after btree_gist is installed, the following constraint will ...


6

Windows Vista Service Pack 1 is actually not supported by SQL Server 2008 R2. In addition to my multiple suggestions to really clean 2008 R2 off your system (again see instructions here), I strongly recommend you install Service Pack 2 before trying again. If you're going to completely reinstall your OS, you might consider Windows 7 which has a longer ...


5

If you are able to shut your database server down (and my understanding is that you are indeed able to) - thereby disabling your application - then that's the easiest indeed. You can, after shutdown, just copy+paste your data directory. Where is your data in the first place? Just issue: SELECT @@datadir; From within your MySQL server. By the way, while ...


5

Have never encountered anything remotely like this and suspect something has been lost in translation. I will of course apply the usual caveat for licensing questions, "don't take anything you read here as gospel, check it with your licensing partner, and Microsoft, and call both back to speak to a different individual. There's a good chance you'll get a ...


5

You will select "Microsoft SQL Server 2012 (64-bit)" Upon loading of the setup wizard, you will select the instance for SQL Server 2012. The next screen you check the shared component you want to remove.


5

That is not a supported upgrade path. how would you recommend I proceed? My recommendation would be to install side-by-side and then migrate (backup and restore) your databases to the SQL Server 2014 instance.


5

A simple and complete solution to error ' Could not find database engine startup handle' in below link Reason for the error can be 1.The account which user selected on Server Configuration page window ( during installation) is somehow not able to bring SQL Server database engine services online. Either is lacks privilege or it is corrupted. During ...


5

Neither MySQL nor Yum are explicitly aware of RAID at all. All mySQL cares about is that it has filesystems to put its files on, if that is hosted on a RAID volume (or NFS share, or anything else) or not makes no difference to it. The same for Yum - it is just a package manager and does not need to be aware of the intricacies of the block device the ...


5

Check out Howard Roger's gladstone shell script. His scripts have always done a great job for me in performing all the necessary pre-installation tasks.


5

Unfortunately, no. You are installing a program and making service and registry changes, etc. You need to run setup as an account that has local administrative rights. No workaround to this that wouldn't involve some back door into administrative rights. Best bet is to ask for someone to temporarily give you the rights or install it for you. Source: The ...


5

You can actually find out where your compiled binary is instructed to read options files. $ mysqld --help --verbose 110923 17:09:29 [Warning] Can't create test file /usr/local/mysql-5.6.2-m5-osx10.6-x86_64/data/laptop1113-2.lower-test 110923 17:09:29 [Warning] Can't create test file /usr/local/mysql-5.6.2-m5-osx10.6-x86_64/data/laptop1113-2.lower-test ...


5

Its a two step process. In the installer select Maintenance/Edition Upgrade to upgrade your existing instance. Run the installer again and select Installation/...or add features to an existing installation/Add features to an existing instance.


4

You should be able to do everything you learn about 10g with 11g as well. In fact, I would recommend to go for the most current version anyway, if you have the choice.


4

I believe that all discs are the same, only the Product key will make the difference once entered during the setup.



Only top voted, non community-wiki answers of a minimum length are eligible