*Note that PG10 was installed on this server. Prior to installing the new version, I stopped and disabled the PG10 service.* Here's the OS version of the server in question: I used the EDB installers linked from the main postgres site: https://www.postgresql.org/download/windows/ I was unable to install PG16 on a client's system due to the error: Failed to Load SQL Modules into Database Clusters which occurred near the end of installation. I have installed PG16 on Win10 and Win11 before (as well as some other Win Server OS's on client systems - but I'm not sure exactly what server versions) and have not run into this issue before. After I clicked through the error and the installation completed, the postgres service refused to start with Error 1067: The process terminated unexpectedly I tried a lot of suggestions I found online (many from this post ) Here's a full list of what I tried: - Rebooting the server - Installing as admin - Installing outside of the Program Files folder (C:\PostgreSQL) - Creating the PostgreSQL and data folders prior to install and giving full permissions to: User Group, Admin Group and the NETWORK SERVICE user. - Setting the service user to Local System, and also the local admin. - Using the default password ("postgres") in the installer - Explicitly setting the locale to English US in the installer I also tried to manually patch the install with some commands I found online: (initialize the DB cluster) initdb -D "C:\PostgreSQL\16\data" -U postgres -A password --pwfile=passwd.txt (simulate postgres service run) "C:\PostgreSQL\16\postgres.exe" -D "C:\PostgreSQL\16\data" The command to init the DB succeeded, but when I tried the second command (simulate service), I immediately got a generic Windows "PostgreSQL has stopped working" error. This is what the event viewer showed: > Faulting application name: postgres.exe, version: 16.0.4.0, time stamp: 0x66b37331 Faulting module name: ucrtbase.dll, version: 10.0.14393.7426, time stamp: 0x66f600f9 Exception code: 0xc0000409 Fault offset: 0x000000000006c9e8 Faulting process id: 0x1b38 Faulting application start time: 0x01dbfc1356b9793c Faulting application path: C:\Program Files\PostgreSQL\16\bin\postgres.exe Faulting module path: C:\Windows\System32\ucrtbase.dll Report Id: c29be876-cf53-4689-b6df-459d3bc7df35 Faulting package full name: Faulting package-relative application ID: Searching online suggested this might be due to issues with the server's runtime libraries, but this was starting to go way over my head. We tried installing PG15 and got the same errors. Eventually we tried going all the way back to PG12, and that worked. I know postgres made significant changes between 12 and 13. PG12 is EOL now, so it's not ideal to use that instead of a newer version, but this was the latest version we could get working. We will likely keep it as is for now, but I would appreciate any further insights or troubleshooting tips in case we decide to revisit the upgrade, or in case this happens with another client. Any help is much appreciated!

When trying to create a maintenance plan locally on two prod servers through SSMS, I receive this error: No such error occurs on my UAT system. They're all running SQL Server 2017 (14.0.3162.1), and they were all installed with the same feature set. The UAT machine is Windows 10, while the prod servers are Windows Server 2016. Which components/features specifically need to be installed such that I can create a maintenance plan?

![enter image description here ][1] ps://i.sstatic.net/0DX0d.png I am trying to install the Oracle database 12c on the Windows 10 Laptop. Have tried disk C and disk E, got the same error. And I tried to change the file properties, change the security to allow the full control.. And still got the same error message. Anyone could help me with this? Thank you!!!!

I installed postgres like this:, - sudo apt install postgresql postgresql-contrib - sudo systemctl is-active postgresql, returned active - sudo systemctl is-enabled postgresql, returned enabled - sudo systemctl status postgresql, returned active but when I try confirming if the Postgresql server is ready to accept connections from clients as follows: - sudo pg_isready, this returned /var/run/postgresql:5432 - no response. I've tried all with no success please help, thanks in advance. OS: Linux Mint "Uma"

My company has grown from 50 SQL Servers to over 200 overnight in a merger acquisition. HELP! My questions are: - How can I perform CU updates on this many servers and still have a life and keep my sanity? SCCM doesn't seem to be able to perform CU updates. - Has anyone else been able to perform CU updates on 100s of servers? - What are some other alternatives?

I am new to Oracle Database Installation and I tried to install newer version but it does not work, and when I get a full documentation on how to install version 12c, somehow I got an error out of memory. When I check in this path: ***/u01/app/oracle/cfgtoollogs/dbca/orcl***

[ 2023-04-19 16:37:55.751 GMT ] Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 2%
[ 2023-04-19 16:38:01.236 GMT ] ORA-27102: out of memory

DBCA_PROGRESS : 3%
[ 2023-04-19 16:38:01.238 GMT ] ORA-01034: ORACLE not available

[ 2023-04-19 16:38:02.301 GMT ] ORA-01034: ORACLE not available

[ 2023-04-19 16:38:02.305 GMT ] ORA-01034: ORACLE not available

[ 2023-04-19 16:38:07.537 GMT ] DBCA_PROGRESS : DBCA Operation failed.

When I check in this path: ***/u01/app/oracle/diag/rdbms/orcl/orcl/trace***

2023-04-19T16:38:01.221832+00:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 

2023-04-19T16:38:01.221951+00:00
 Per process system memlock (soft) limit = 128G
2023-04-19T16:38:01.222002+00:00
 Expected per process system memlock (soft) limit to lock
 SHARED GLOBAL AREA (SGA) into memory: 820M
2023-04-19T16:38:01.222103+00:00
 Available system pagesizes:
  4K 
2023-04-19T16:38:01.222200+00:00
 Supported system pagesize(s):
2023-04-19T16:38:01.222254+00:00
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
2023-04-19T16:38:01.222306+00:00
        4K       Configured          209924            2149   ORA-27102
2023-04-19T16:38:01.222355+00:00

My current config during installation is this:

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 1987162112
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586

My current memory: ***[root@testing etc]# free -m***

total        used        free      shared  buff/cache   available
Mem:           2048         855         269         496         922         696
Swap:           512         191         320

After close the installer and check back my RAM

total        used        free      shared  buff/cache   available
Mem:           2048          76        1120         496         850        1474
Swap:           512          24         487

Can you help me to identify the correct config for my database?

I am trying to install parray_gin in PostgreSQL 10 on macOS, but I can't get it to build. I'm running pgxn install parray_gin. This first gave me a missing stdio.h error, so I installed the xcode command line tools, and now it's complaining about /Library/PostgreSQL/10/include/postgresql/server/utils/pg_locale.h:19:10: fatal error: 'unicode/ucol.h' file not found After some Googling it appeared I needed to install an extra library, which I did through brew install icu4c This printed: This formula is keg-only, which means it was not symlinked into /usr/local, because macOS provides libicucore.dylib (but nothing else). If you need to have this software first in your PATH run: echo 'export PATH="/usr/local/opt/icu4c/bin:$PATH"' >> ~/.bash_profile echo 'export PATH="/usr/local/opt/icu4c/sbin:$PATH"' >> ~/.bash_profile For compilers to find this software you may need to set: LDFLAGS: -L/usr/local/opt/icu4c/lib CPPFLAGS: -I/usr/local/opt/icu4c/include But it didn't change a thing and I have no idea how to pass /usr/local/opt/icu4c/include to pgxn

Can we install and run PL/SQL Developer on CentOS 7 server? I couldn't find installation documents anywhere. If the installation is possible can someone guide me on this.

My *vendor* directory from Composer is in the Home directory of my Linux user account. And I am very allergic to loading files into projects with something arbitrary as the user account name in the directory-link. Preferably, I'd like the *vendor* directory much closer to the web-directory (but not in public of course). What is making me very insecure is that in most examples I see from others, is that they do have the vendor directory at a much more convenient place and closer to the public-server-root. I googled all night on how to move my vendor folder, and I didn't find anything in plain English that I could understand. I guess I am not the smartest. And Linux is moslty headaches and anger for me. And I am surprised by the outcome of my *vendor* directory location as I did what most tutorials showed. cd /var/www php -r "copy('https://getcomposer.org/installer ', 'composer-setup.php');" php -r "if (hash_file('sha384', 'composer-setup.php') === 'dac665fdc30fdd8ec78b38b9800061b4150413ff2e3b6f88543c636f7cd84f6db9189d43a81e5503cda447da73c7e5b6') { echo 'Installer verified'.PHP_EOL; } else { echo 'Installer corrupt'.PHP_EOL; unlink('composer-setup.php'); exit(1); }" php composer-setup.php php -r "unlink('composer-setup.php');" *Most likely, you want to put the composer.phar into a directory on your PATH, so you can simply call composer from any directory (Global install), using for example:* sudo mv composer.phar /usr/local/bin/composer I did look at composer.json. But I found nothing on how to re-link a vendor directory in that file, as I do not care if that file stays in the User home dir. Anyone with words of wisdome, advice, or plain old telling me what I did wrong?

This is the error I encountered (I ran the db2_install and everything else as root,): DBI1288E The execution of the program /home/DB_SERVER/ibm/db2/v10.5 failed. This program failed because you do not have write permission on the directory or file . I tried to change the access permission of the path: chmod -R a+rw /home/DB_SERVER/ibm/db2/v10.5 And then I could create a new file in that folder: vi test Result of ll in that directory: total 1 -rw-rw-rw- 1 root root 12 Nov 23 00:24 test But when I ran the db2_install again, it failed for the same reason. PS: I tried to change permission of the setup file too chmod -R a+rwx db2Setup/ Result of ll total 72 drwxrwxrwx 6 root root 4096 Nov 23 00:10 db2 -rwxrwxrwx 1 root root 5349 Nov 23 00:10 db2ckupgrade -rwxrwxrwx 1 root root 5302 Nov 23 00:10 db2_deinstall -rwxrwxrwx 1 root root 5172 Nov 23 00:10 db2_install -rwxrwxrwx 1 root root 5136 Nov 23 00:10 db2ls -rwxrwxrwx 1 root root 5154 Nov 23 00:10 db2prereqcheck -rwxrwxrwx 1 root root 5154 Nov 23 00:10 db2setup drwxrwxrwx 10 root root 4096 Nov 23 00:10 ibm_im -rwxrwxrwx 1 root root 5190 Nov 23 00:10 installFixPack drwxrwxrwx 4 root root 4096 Nov 23 00:10 nlpack -rw-r--r-- 1 root root 8 Nov 23 01:00 test So I have no idea what's wrong? How to fix this?

I have downloaded Cassandra from here https://www.apache.org/dyn/closer.lua/cassandra/5.0.4/apache-cassandra-5.0.4-bin.tar.gz , i have extracted it and set the environment variable as well, but when i run Cassandra or cqlsh i get `is not recognized as an internal or external command, operable program or batch file.` I did look into it's bin folder, and i don't see any exe or bat file's, So how do i run in in Windows? is there something i'm missing? is there any other link's to download it?

I am facing some issues related to SSRS on SQL Server 2008R2, how can we have install below features: Reporting Services- SharePoint Reporting Services Add-in for SharePoint Products Any one could you please help me. Thanks

I've installed and configured postgresql in Linux successfully, 1. postgres user created 2. new db created successfully 3. I'm trying to connect using pgadmin III (Windows) 4. Following details are adding in pgadmin window Host: DEMO Host: XXXX Port: 5432 Maintenance DB: postgres Username: postgres password: G0!mf17. 5. Clicked on OK It's tried to connect and displayed message connecting to database.... Failed. I'm not sure why it's failed and what needs to configure in linux system. I'm new to linux, If anyone able to guide me solve this issue it will be greatful. Please let me know if you need more details.

I have an Oracle database 11gr2 and I want to install Oracle Grid on Oracle Linux 6.4. At first, I have installed Oracle Grid with the tutorial on this website: https://eudba.wordpress.com/2012/08/10/installing-oracle-11g-on-oracle-linux-6-with-asm-eng/ When the grid installation is finished, I have an error that says: "the Oracle grid service can not start". When I want to install the database with oracle user and with ASM, I have an error that I attached it to this question. Can any one help me?

According to db2level, we're currently running DB2 v11.5.7.0 (on RHEL 7.9). It was upgraded from 11.5 before I arrived. This might sound like a stupid question, but are the V11.5 files required for V11.5.7.0, or is V11.5.7.0 fully stand-alone so that I can remove /opt/ibm/db2/V11.5? (I think the answer is "yes", but there's no test system for me to experiment on, and I don't want to break production.) Both V11.5/ and V11.5.7.0 see to be full installations: $ du -cm -d1 /opt/ibm/db2 du: cannot read directory ‘/opt/ibm/db2/V11.5/.licbkup’: Permission denied 2270 /opt/ibm/db2/V11.5 du: cannot read directory ‘/opt/ibm/db2/V11.5.7.0/.licbkup’: Permission denied 2150 /opt/ibm/db2/V11.5.7.0 4420 /opt/ibm/db2 4420 total More details: $ /sbin/lsof -u db2dlp01 | grep V11.5/ $ echo $? 1 $ /sbin/lsof -u db2dlp01 | grep -q V11.5.7.0 $ echo $? 0 $ /opt/ibm/db2/V11.5/bin/db2greg -dump S,DB2,11.5.0.0,/opt/ibm/db2/V11.5,,,0,0,,1610467335,0 V,DB2GPRF,DB2SYSTEM,ewr0vlpudb01dol,/opt/ibm/db2/V11.5, S,TSA,4.1.0.7,/opt/IBM/tsamp,DG_NOT_ALLOWED,DB2_INSTALLED,0,0,-,1651371491,0 S,RSCT,3.2.6.2,/usr/sbin/rsct,DG_NOT_ALLOWED,DB2_INSTALLED,0,0,-,1651371491,0 S,DB2,11.5.7.0,/opt/ibm/db2/V11.5.7.0,,,0,0,,1651371660,0 V,DB2GPRF,DB2SYSTEM,ewr0vlpudb01dol,/opt/ibm/db2/V11.5.7.0, I,DB2,11.5.7.0,db2dlp01,/home/db2dlp01/sqllib,,1,0,/opt/ibm/db2/V11.5.7.0,, $ /opt/ibm/db2/V11.5.7.0/bin/db2greg -dump S,DB2,11.5.0.0,/opt/ibm/db2/V11.5,,,0,0,,1610467335,0 V,DB2GPRF,DB2SYSTEM,ewr0vlpudb01dol,/opt/ibm/db2/V11.5, S,TSA,4.1.0.7,/opt/IBM/tsamp,DG_NOT_ALLOWED,DB2_INSTALLED,0,0,-,1651371491,0 S,RSCT,3.2.6.2,/usr/sbin/rsct,DG_NOT_ALLOWED,DB2_INSTALLED,0,0,-,1651371491,0 S,DB2,11.5.7.0,/opt/ibm/db2/V11.5.7.0,,,0,0,,1651371660,0 V,DB2GPRF,DB2SYSTEM,ewr0vlpudb01dol,/opt/ibm/db2/V11.5.7.0, I,DB2,11.5.7.0,db2dlp01,/home/db2dlp01/sqllib,,1,0,/opt/ibm/db2/V11.5.7.0,, More info: $ /usr/local/bin/db2ls Install Path Level Fix Pack Special Install Number Install Date Installer UID --------------------------------------------------------------------------------------------------------------------- /opt/ibm/db2/V11.5 11.5.0.0 0 Tue Jan 12 11:02:15 2021 EST 0 /opt/ibm/db2/V11.5.7.0 11.5.7.0 0 Sat Apr 30 22:21:00 2022 EDT 0

I want to know how to install SAP HANA DB 2.0 on Oracle Linux 7 including downloading, installing and the first connection establishing to the system from network. I've spent a few hours to find out how to do it, but haven't found all required information in one place.

I use "sudo dnf install mariadb" to install mariadb on fedora36 but it showed me this error: **" file /etc/my.cnf from install of MariaDB-common-10.9.2-1.fc36.x86_64 conflicts with file from package mariadb-connector-c-config-3.2.7-1.fc36.noarch "** what should i do to install mariadb on my system??

There are other Installation related questions with similar details here and here . I could not find anything related to listing the installed features in sql server 2016 though. I can do it manually looking at the logs - as per the info below, but I would like to automate it. After installing SQL Server 2016 I get a log file - located somewhere in these folders: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20200109_205540 A file which the name starts with Summary_ +my_server_name in that file, amongst other things I can find a list of the Sql Server Features installed: After installation, later on when the systems are already in use, logins and permissions applied, firewall fixed, etc. Is there a simple way to get hold of the list of features installed on a sql server instance?

What is the recommended way to perform a minor upgrade from PostgreSQL e.g. 9.3.0 to 9.3.1 using the Enterprise DB built windows installer? Should I uninstall first or just install over the existing installation? The current installation was performed with postgresql-9.3.0-1-windows-x64.exe. Now I want to upgrade using postgresql-9.3.1-1-windows-x64.exe.

I am trying to create an Oracle 19c single instance (warehouse) with dbca silent mode. The problem is, when I try the command below, it gets a warning: "Ora-0058: DB_BLOCK_SIZE must be 8192 to mount this database (not 32768)". Rest of the lines are full of errors. The command: dbca -silent -createDatabase -initparams db_block_size=32768 -templateName Data_Warehouse.dbc -gdbname ${ORACLE_SID} -sid ${ORACLE_SID} -responseFile NO_VALUE -characterSet WE8ISO8859P9 -sysPassword SysPassword1 -systemPassword SysPassword1 -databaseType DATA_WAREHOUSING -memoryPercentage 40 -memoryMgmtType AUTO_SGA -storageType FS -datafileDestination "${DATA_DIR}" -redoLogFileSize 2048 -emConfiguration NONE -ignorePreReqs I assume this is because of the template I'm using. But I don't have any custom templates. Also I don't want to use GUI as I'm not going to have this option for certain reasons. How can I fix the command so dbca won't fail?