02-12-2013
If the primary files and any mirrors are gone, restore from the transaction logs is usually the only path.
9 More Discussions You Might Find Interesting
1. Cybersecurity
Help!
SCO Unix 5.05.
A relatievely new system went down on me today. I got the dreaded error:
Out of Space on Device (1/42).
I was able to clear up some space in the /tmp directory, however, when I try to boot, the system prompts me to go into single user mode and I get the... (2 Replies)
Discussion started by: gseyforth
2 Replies
2. UNIX for Dummies Questions & Answers
Hi guys,
For some reason a client has given us a Sun Netra T1 with Solaris 8 to administer for them. That's always good business. However, the other day we rebooted the machine and to our amazement, after doing the preliminary hardware tests, we got an error messgae saying that /etc/inittab was... (3 Replies)
Discussion started by: Ivo
3 Replies
3. UNIX for Dummies Questions & Answers
Hmm, how to ask this without sounding too malicious...
How might one go about causing a disk corruption in OS X specifically or via the command line in UNIX in general?
Doesnt matter the severity of the problem, I just want to scare the person a little, then fix the problem for them.
Any... (1 Reply)
Discussion started by: Yummator
1 Replies
4. HP-UX
I have been fine adding/removing printers up until this week. Now when I go to add a new remote printer I get "corrupted member file". I go to /etc/lp/member and the byte count on the new printer name is 0. I VI the file and put /dev/null in to make it the correct size and it all looks fine and... (2 Replies)
Discussion started by: astout
2 Replies
5. Shell Programming and Scripting
Hi All,
Has anyone of you connected to a remote PostgreSQL database through a shell/perl script. Can you please let me know the steps involed?
Thanks.
Rahul. (0 Replies)
Discussion started by: rahulrathod
0 Replies
6. Solaris
I need to corrupt a superblock of a mounted device in a soalris m/c and check recovery from an alternate superblock. How can this be done? (2 Replies)
Discussion started by: sujathan
2 Replies
7. HP-UX
Hallo Friends,
I have application X running on hpux 11.11 and oracle 9i release 2. I recently had a hardware failure on disk /dev/dsk/c2t0d0
Below is the systemlog file :
root@a7dmc:/var/adm/syslog > /opt/resmon/bin/resdata -R 155713541 -r /storage/events/enclosures/gazemon/0_1_1_0.0.0... (11 Replies)
Discussion started by: kekanap
11 Replies
8. Shell Programming and Scripting
Hi,
Closing the thread (3 Replies)
Discussion started by: dbashyam
3 Replies
9. Shell Programming and Scripting
Hi
I have a small bash script which I want to run on an Amazon EC2 Ubuntu instance for setting up a postgreSQL database:
#!/bin/bash
USERNAME='postgres'
start=$SECONDS
TMP_DIR=/local/test/4g4d
PORT=23456
rm -rf $TMP_DIR/db
mkdir -p $TMP_DIR/
echo "creating database..."... (3 Replies)
Discussion started by: Helveticus
3 Replies
LEARN ABOUT DEBIAN
pg_wrapper
PG_WRAPPER(1) Debian PostgreSQL infrastructure PG_WRAPPER(1)
NAME
pg_wrapper - wrapper for PostgreSQL client commands
SYNOPSIS
client-program [--cluster version/cluster] [...]
(client-program: psql, createdb, dropuser, and all other client programs installed in /usr/lib/postgresql/version/bin).
DESCRIPTION
This program is run only as a link to names which correspond to PostgreSQL programs in /usr/lib/postgresql/version/bin. It determines the
configured cluster and database for the user and calls the appropriate version of the desired program to connect to that cluster and
database, supplying any specified options to that command.
The target cluster is selected by the following means, in descending order of precedence:
1. explicit specification with the --host option
2. explicit specification with the --cluster option
3. if the PGHOST environment variable is set, no further cluster selection is performed. The default PostgreSQL version and port number
(from the command line, the environment variable PGPORT, or default 5432) will be used.
4. explicit specification with the PGCLUSTER environment variable
5. matching entry in ~/.postgresqlrc (see postgresqlrc(5)), if that file exists
6. matching entry in /etc/postgresql-common/user_clusters (see user_clusters(5)), if that file exists
7. If only one local cluster exists, that one will be selected.
8. If several local clusters exist, the one listening on the default port 5432 will be selected.
If none of these rules match, pg_wrapper aborts with an error.
OPTIONS
--cluster version/cluster
cluster is either the name of a local cluster, or takes the form host:port for a remote cluster. If port is left empty (i. e. you just
specify host:), it defaults to 5432.
ENVIRONMENT
PGCLUSTER
If $PGCLUSTER is set, its value (of the form version/cluster) specifies the desired cluster, similar to the --cluster option. However,
if --cluster is specified, it overrides the value of $PGCLUSTER.
PG_CLUSTER_CONF_ROOT
This specifies an alternative base directory for cluster configurations. This is usually /etc/postgresql/, but for testing/development
purposes you can change this to point to e. g. your home directory, so that you can use the postgresql-common tools without root
privileges.
FILES
/etc/postgresql-common/user_clusters
stores the default cluster and database for users and groups as set by the administrators.
$HOME/.postgresqlrc
stores defaults set by the user himself.
SEE ALSO
user_clusters(5), postgresqlrc(5)
AUTHOR
Martin Pitt <mpitt@debian.org>
Debian 2013-01-04 PG_WRAPPER(1)