LOAD(7) PostgreSQL 9.2.7 Documentation LOAD(7)NAME
LOAD - load a shared library file
SYNOPSIS
LOAD 'filename'
DESCRIPTION
This command loads a shared library file into the PostgreSQL server's address space. If the file has been loaded already, the command does
nothing. Shared library files that contain C functions are automatically loaded whenever one of their functions is called. Therefore, an
explicit LOAD is usually only needed to load a library that modifies the server's behavior through "hooks" rather than providing a set of
functions.
The file name is specified in the same way as for shared library names in CREATE FUNCTION (CREATE_FUNCTION(7)); in particular, one can rely
on a search path and automatic addition of the system's standard shared library file name extension. See Section 35.9, "C-Language
Functions", in the documentation for more information on this topic.
Non-superusers can only apply LOAD to library files located in $libdir/plugins/ -- the specified filename must begin with exactly that
string. (It is the database administrator's responsibility to ensure that only "safe" libraries are installed there.)
COMPATIBILITY
LOAD is a PostgreSQL extension.
SEE ALSO
CREATE FUNCTION (CREATE_FUNCTION(7))
PostgreSQL 9.2.7 2014-02-17 LOAD(7)
Check Out this Related Man Page
MODULES-LOAD.D(5) modules-load.d MODULES-LOAD.D(5)NAME
modules-load.d - Configure kernel modules to load at boot
SYNOPSIS
/etc/modules-load.d/*.conf
/run/modules-load.d/*.conf
/usr/lib/modules-load.d/*.conf
DESCRIPTION systemd-modules-load.service(8) reads files from the above directories which contain kernel modules to load during boot in a static list.
Each configuration file is named in the style of /etc/modules-load.d/program.conf. Note that it is usually a better idea to rely on the
automatic module loading by PCI IDs, USB IDs, DMI IDs or similar triggers encoded in the kernel modules themselves instead of static
configuration like this. In fact, most modern kernel modules are prepared for automatic loading already.
CONFIGURATION FORMAT
The configuration files should simply contain a list of kernel module names to load, separated by newlines. Empty lines and lines whose
first non-whitespace character is # or ; are ignored.
Each configuration file shall be named in the style of program.conf. Files in /etc/ override files with the same name in /usr/lib/ and
/run/. Files in /run/ override files with the same name in /usr/lib/. Packages should install their configuration files in /usr/lib/, files
in /etc/ are reserved for the local administrator, who may use this logic to override the configuration files installed from vendor
packages.
If the administrator wants to disable a configuration file supplied by the vendor, the recommended way is to place a symlink to /dev/null
in /etc/modules-load.d/ bearing the same filename.
EXAMPLE
Example 1. /etc/modules-load.d/virtio-net.conf example:
# Load virtio-net.ko at boot
virtio-net
SEE ALSO systemd(1), systemd-modules-load.service(8), systemd-delta(1), modprobe(8)systemd 208MODULES-LOAD.D(5)
now, i have been reading alot of books about this load balancing thing. when looking at the output of iostat and one determines that the disks do not have roughly equivalent utilization rate, books i've read mentions balancing the loads so the loads are spread evenly across the disks.
Now, i... (6 Replies)
Hi all,
I am new to sco unix.
I would like to know abt the procedure to create shared library in Sco-unix.
Is it differ from linux?
any help??
Thanx in Advance!!!!! (0 Replies)
Hi,
I am trying to create shared library. When i run the script to build the library i get these errors
ld: warning: option -o appears more than once, first setting taken
ld: fatal: file libgc.so.0: open failed: No such file or directory
ld: fatal: File processing errors. No output written... (0 Replies)
https://www.unix.com/showpost.php?p=98416&postcount=8
Referring to the post above... what is the unit that is measured in the TOP command under LOAD? (1 Reply)
Hi All,
I am trying to load a data from a files in a particular directory to a database..
cd $SCC
isql metdb >> ${LOGDATA}/LOAD.LOG < !
load from "${LDATA}/${FORM}.ld" insert into $LOADTABLE
!
But it's showing the error "syntax error at line 46 : `<<' unmatched"
Can u plz help me... (5 Replies)
I have a csv file in a folder that is roughly 500,000 rows long.
Rather than using PHP, I would like to use SH to run a MYSQL LOAD DATA command to load the data in, as I think it would be much faster and would not cause any memory problems associated with PHP.
But the problem is, I am not... (18 Replies)
I have a control file which looks like this
LOAD DATA
INFILE '/array/data/data_Finished_T5_col_change/home/oracle/emp.dat'
PRESERVE BLANKS
INTO TABLE SCOTT.EMP
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(.................
..................)
How can i edit the... (1 Reply)
hello there,
can someone please tell me the commands that makes sense, from a production point of view, to be used to make sure CPU, LOAD or IO usages on a Linux or Solaris server isn't too high?
I'm aware of vmstat, iostat, sar. But i seriously need real world advice as to what fields in... (1 Reply)
We are facing issue with shared library file, we are getting difference in content for same shared file for chatr command :confused: , below are the detail about *.sl file, even we are also getting difference in size of both file. can you please tell me what will be the issue for same. is my new... (1 Reply)
Hi ,
I am using below control file
LOAD DATA
APPEND
INTO TABLE LSHADMIN.EG
TRAILING NULLCOLS
(
STUDY CHAR
)
and the text file to load data is
CACZ885M2301
When I run below command:
sqlldr userid=apps/apps control=/home/appsuser/dataload/ctl_file.ctl... (3 Replies)
I have query to replace the first word in line using below code but its replace the middle word too
sed -i 's/load /# LOAD/' /tmp/check.sql
Query 1 :
UPDATE accheadcon_data_last_upload SET last_upload_date = '2017-07-23'
Replace to
UPDATE accheadcon_data_last_up# LOAD SET... (1 Reply)