Setting up postgreSql database Post: 302920323

7 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

UX Kernel setting while database installation

Hi All I am kinda wondering about the UX kernel parameters, how we configure and why do we configure ???.. especially the 'semaphores'. Could somebody throw some light on this and would really appreciate it.

2. Shell Programming and Scripting

Script to connect to PostgreSQL database

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.

3. Programming

kill - postgresql

Hi guys. I was was designing a simple database in postgresql. I wrote a perl function in postgresql and execute it. suddenly i saw that it is running in an infinite loop. After i stopped executing of the query, i saw that CPU is in 90%+ load. I looked at process list and there it was. postgresql...

4. Shell Programming and Scripting

CRON Job to copy database and replace existing database

I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the...

5. Solaris

Postgresql installation

Hi all, I want to install two postgreql 8.3.5 instances on same servers. already one instalce is running on default port and i need it to be installed on another port.. How ever i achived installing the second instance.. but the problem is if i create a new user using createuser in the newly...

6. High Performance Computing

Postgresql Database Corrupt

I am managing a linux cluster which has been build on Platform Cluster Manager PCM 1.2.1) from IBM Platform Computing. Unfortunately somebody deteled data files of postgresql from /var/lib directory. I somehow managed to start the postmaster service again, but all the administrative commands of...

7. UNIX for Beginners Questions & Answers

Setting config database user and password using sed

Hello everybody, I need to modify 200 files using a patern matching, I would like to do it with sed but it's not working with the following syntax: sed -e 's/DATABASE_PASSWORD.*oldpass/DATABASE_PASSWORD__', 'newpass/g' config.php need to find: define("__DATABASE_PASSWORD__", ...

LEARN ABOUT MOJAVE

topsyscall

topsyscall(1m)							   USER COMMANDS						    topsyscall(1m)

NAME

       topsyscall - top syscalls by syscall name. Uses DTrace.

SYNOPSIS

       topsyscall [-Cs] [interval [count]]

DESCRIPTION

       This  program  continually prints a report of the top system calls, and refreshes the display every 1 second or as specified at the command
       line.

       Since this uses DTrace, only users with root privileges can run this command.

OPTIONS

       -C     don't clear the screen

       -s     print per second values

EXAMPLES

       Default output, 1 second updates,
	      # topsyscall

       Print every 5 seconds,
	      # topsyscall 5

       Print a scrolling output,
	      # topsyscall -C

FIELDS

       load avg
	      load averages, see uptime(1)

       syscalls
	      total syscalls in this interval

       syscalls/s
	      syscalls per second

       SYSCALL
	      system call name

       COUNT  total syscalls in this interval

       COUNT/s
	      syscalls per second

DOCUMENTATION

       See the DTraceToolkit for further documentation under the Docs directory. The DTraceToolkit docs may include full worked examples with ver-
       bose descriptions explaining the output.

EXIT

       topsyscall will run until Ctrl-C is hit, or the specified interval is reached.

AUTHOR

       Brendan Gregg [Sydney, Australia]

SEE ALSO

       dtrace(1M), prstat(1M)

version 0.90							   Jun 13, 2005 						    topsyscall(1m)