Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Checking which databases are installed Post 302173850 by figaro on Saturday 8th of March 2008 10:10:12 AM
Old 03-08-2008
Checking which databases are installed

I want to check which databases are installed on my FreeBSD installation. This is what I did: pkg_info | grep mysql
How do I check all in one go whether also sqlite, postgresql, firebird is installed?

Thanks in advance
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Unix and databases

I had a person ask me if a Sql database can be run with Unix? I don't know can this be done? They only have Sql dba's and no oracle dba but want to use a Unix box???? (1 Reply)
Discussion started by: tyranunn
1 Replies

2. Shell Programming and Scripting

Checking whether program is installed

I currently use this construction to check whether a certain program is installed: if ; then cd /usr/ports/databases/sqlite3 && make install clean else echo "sqlite already installed" fi Is this method recommended? Is this an effective method, ie sufficiently robust for... (3 Replies)
Discussion started by: figaro
3 Replies

3. Shell Programming and Scripting

checking which mysql dbd is installed on linux

Hi, I am new to linux, and i want to know which mysql dbd is installed on linux, what is the command to check this. bash-2.05$ uname -a Linux SURINT01 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Thanks Prakash GR (6 Replies)
Discussion started by: prakash.gr
6 Replies

4. AIX

OS Patches installed but they seem as not installed

Hello everyone: I've installed an OS patch into AIX 6.1 by running the following command: instfix -d /tmp/6100-02-03 -k "IZ41855" however it seem not installed instfix -i -k "IZ41855" There was no data for IZ41855 in the fix database. what am I doing wrong? (8 Replies)
Discussion started by: edgarvm
8 Replies

5. Shell Programming and Scripting

Two databases

Hello, I have two databases one is student_Name and another is student_Name1...Two tabled contain 200 records each..I found that near 30 names are entered in both databases..I would like to remove the duplicates..and i have to keep the name which is newly added..Please hepl how to remove... (7 Replies)
Discussion started by: Anjali_vee
7 Replies

6. Red Hat

Trouble with installed / not installed rpm unixODBC/libodbc.so.1

Hey there, i run 1: on my server (RHEL 6) and getting response that the libodbc is not installed. If i use yum for installation, it tells me, there is no package like this ( 2: ). Since in the description of Definiens is mentioned that the Run-time dependency is unixODBC (libodbc.so.1), I assume... (2 Replies)
Discussion started by: rkirsten
2 Replies

7. Shell Programming and Scripting

Need help in backing up of databases.

Hi Everyone, I am new to DBA stuff. I wonder if anyone can help me. Task is that, I have 10 databases and need to take backups of all the databases using data pump in Unix/Linux, compress them using gzip and use cron to schedule the job twice a day. Appreciate if anyone can help me in... (1 Reply)
Discussion started by: sreepriya0987
1 Replies

8. SCO

Stop boot system at "Checking protected password and checking subsystem databases"

Hi, (i'm sorry for my english) I'm a problem on boot sco unix 5.0.5 open server. this stop at "Checking protected password and checking subsystem databases" (See this image ) I'm try this: 1) http://www.digipedia.pl/usenet/thread/50/37093/#post37094 2) SCO: SCO Unix - Server hangs... (9 Replies)
Discussion started by: buji
9 Replies

9. Programming

MySQL Databases

Hello all again, How do you guys backup your MySQL databases? I have a few programs that have an default back up that make an .sql file which is great but I also use OpenX which runs on PHP and has a database. That does not have an auto-back-up feature so do I just download the... (2 Replies)
Discussion started by: AimyThomas
2 Replies

10. UNIX for Beginners Questions & Answers

Bash find version of an installed application but if none is found set variable to App Not Installed

Hello Forum, I'm issuing a one line bash command to look for the version of an installed application and saving the result to a variable like so: APP=application --version But if the application is not installed I want to return to my variable that the Application is not installed. So I'm... (2 Replies)
Discussion started by: greavette
2 Replies
PKG_INFO(1)						    BSD General Commands Manual 					       PKG_INFO(1)

NAME
pkg_info -- a utility for displaying information on software packages SYNOPSIS
pkg_info [-BbcDdFfhIikLmNnpqRrSsVvX] [-e package] [-E package] [-K pkg_dbdir] [-l prefix] pkg-name ... pkg_info [-a | -u] [flags] pkg_info [-Q variable] pkg-name ... DESCRIPTION
The pkg_info command is used to dump out information for packages, which may be either packed up in files or already installed on the system with the pkg_create(1) command. The pkg-name may be the name of an installed package (with our without version), a pattern matching several installed packages (see the PACKAGE WILDCARDS section for a description of possible patterns), the pathname to a binary package, a filename belonging to an installed package (if -F is also given), or a URL to an ftp-available package. The following command-line options are supported: -a Show information for all currently installed packages. See also -u. -B Show some of the important definitions used when building the binary package (the ``Build information'') for each package. Addition- ally, any installation information variables (lowercase) can be queried, too. In particular, automatic tells if a package was installed automatically as a dependency of another package. -b Show the NetBSD RCS Id strings from the files used in the construction of the binary package (the "Build version") for each package. These files are the package Makefile, any patch files, any checksum files, and the packing list file. -c Show the one-line comment field for each package. -D Show the install-message file (if any) for each package. -d Show the long-description field for each package. -E pkg-name This option allows you to test for the existence of a given package. If a package identified by pkg-name is currently installed, return code is 0, otherwise 1. The name of the best matching package found installed is printed to stdout unless turned off using the -q option. pkg-name can contain wildcards (see the PACKAGE WILDCARDS section below). -e pkg-name This option allows you to test for the existence of a given package. If a package identified by pkg-name is currently installed, return code is 0, otherwise 1. The names of any package(s) found installed are printed to stdout unless turned off using the -q option. pkg-name can contain wildcards (see the PACKAGE WILDCARDS section below). -F Interpret any pkg-name given as filename, and translate it to a package name using the package database. This can be used to query information on a per-file basis, e.g. in conjunction with the -e flag to find out which package a file belongs to. -f Show the packing list instructions for each package. -I Show the index entry for each package. -i Show the install script (if any) for each package. -K pkg_dbdir Override the value of the PKG_DBDIR configuration option with the value pkg_dbdir. -k Show the de-install script (if any) for each package. -L Show the files within each package. This is different from just viewing the packing list, since full pathnames for everything are generated. Files that were created dynamically during installation of the package are not listed. -l str Prefix each information category header (see -q) shown with str. This is primarily of use to front-end programs that want to request a lot of different information fields at once for a package, but don't necessary want the output intermingled in such a way that they can't organize it. This lets you add a special token to the start of each field. -m Show the mtree file (if any) for each package. -N Show which packages each package was built with (exact dependencies), if any. -n Show which packages each package needs (depends upon), if any. -p Show the installation prefix for each package. -Q Show the definition of variable from the build information for each package. An empty string is returned if no such variable defini- tion is found for the package(s). -q Be ``quiet'' in emitting report headers and such, just dump the raw info (basically, assume a non-human reading). -R For each package, show the packages that require it. -r For each package, show the packages that require it. Continue recursively to show all dependents. -S Show the size of this package and all the packages it requires, in bytes. -s Show the size of this package in bytes. The size is calculated by adding up the size of each file of the package. -u Show information for all user-installed packages. Automatically installed packages (as dependencies of other packages) are not dis- played. See also -a. -V Print version number and exit. -v Turn on verbose output. -X Print summary information for each package. The summary format is described in pkg_summary(5). Its primary use is to contain all information about the contents of a (remote) binary package repository needed by package managing software. TECHNICAL DETAILS
Package info is either extracted from package files named on the command line, or from already installed package information in <PKG_DBDIR>/<pkg-name>. A filename can be given instead of a (installed) package name to query information on the package this file belongs to. This filename is then resolved to a package name using the package database. For this translation to take place, the -F flag must be given. The filename must be absolute, compare the output of pkg_info -aF. PACKAGE WILDCARDS
In the places where a package name/version is expected, e.g. for the -e switch, several forms can be used. Either use a package name with or without version, or specify a package wildcard that gets matched against all installed packages. Package wildcards use fnmatch(3). In addition, csh(1) style {,} alternates have been implemented. Package version numbers can also be matched in a relational manner using the >=, <=, >, and < operators. For example, pkg_info -e 'name>=1.3' will match versions 1.3 and later of the name package. Additionally, ranges can be defined by giving a lower bound with > or >= and an upper bound with < or <=. The lower bound has to come first. For example, pkg_info -e 'name>=1.3<2.0' will match versions 1.3 (inclusive) to 2.0 (exclusive) of package name. The collating sequence of the various package version numbers is unusual, but strives to be consistent. The magic string ``alpha'' equates to alpha version and sorts before a beta version. The magic string ``beta'' equates to beta version and sorts before a release candidate. The magic string ``rc'' equates to release candidate and sorts before a release. The magic string ``pre'', short for ``pre-release'', is a synonym for ``rc''. For example, name-1.3rc3 will sort before name-1.3 and after name-1.2.9. Similarly name-1.3alpha2 will sort before name-1.3beta1 and they both sort before name-1.3rc1. In addition, alphabetic characters sort in the same place as their numeric counter- parts, so that name-1.2e has the same sorting value as name-1.2.5 The magic string ``pl'' equates to a patch level and has the same value as a dot in the dewey-decimal ordering schemes, as does the underscore '_'. ENVIRONMENT
See pkg_install.conf(5) for options, that can also be specified using the environment. SEE ALSO
pkg_add(1), pkg_admin(1), pkg_create(1), pkg_delete(1), pkg_install.conf(5) pkgsrc(7) AUTHORS
Jordan Hubbard most of the work John Kohl refined it for NetBSD Hubert Feyrer NetBSD wildcard dependency processing, pkgdb, depends displaying, pkg size display etc. BSD
February 27, 2010 BSD
All times are GMT -4. The time now is 05:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy