Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

load(7) [suse man page]

LOAD(7) 							   SQL Commands 							   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 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)] SQL - Language Statements 2010-05-14 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 208 MODULES-LOAD.D(5)
Man Page

15 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

LOAD BALANCING (Experienced help needed)

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)
Discussion started by: TRUEST
6 Replies

2. Programming

Why a shared version is needed

Trying to make a library and get this error : *** Warning: This library needs some functionality provided by -lming32. *** I have the capability to make that library automatically link in when *** you link to this library. But I can only do this if you have a *** shared version of the... (1 Reply)
Discussion started by: hirosima
1 Replies

3. UNIX for Dummies Questions & Answers

Listing the contents of a shared Unix library

I am brand new to Unix. This is probably simple, but how do you list the contents of a shared library? I need to see which functions exist in it. Many thanks. (1 Reply)
Discussion started by: mickpoil
1 Replies

4. Shell Programming and Scripting

SED Replace String Help

I have to replace date in Control file every day i run the script control file looks like this $cat pharma.ctl LOAD DATA INFILE '/usr/bin/sqlscripts/SQL.PharmID.20071206.txt' INTO TABLE uname.TEMP_TABLE FIELDS TERMINATED BY '|' TRAILING NULLCOLS (col_names) i tried $sed -e... (2 Replies)
Discussion started by: prash184u
2 Replies

5. AIX

Wrong Shared objects getting loaded

I have two envoirmets(Envoirment A and Envoirment B) running on same server(AIX vesion 5.3).Both have different groups.I am facing a strange problem.Shared objects of one envoirment (Envoirment A)are getting loaded into the second(Envoirment B).So the servers that have dependency on shared objects... (2 Replies)
Discussion started by: nitin@tcs
2 Replies

6. Linux

how to backtrace a shared library file (.so)

I have a shared library file (.so) and I need to know some information 1. By which GCC version was this .so built? 2. Was this .so built in 32 bits mode or 64 bits mode Any command / tools to backtrace such kind of information? Thanks in advance! (2 Replies)
Discussion started by: princelinux
2 Replies

7. Shell Programming and Scripting

unix script for loading a data from a file into database

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)
Discussion started by: grajesh_955
5 Replies

8. Shell Programming and Scripting

sh and MySQL LOAD DATA

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)
Discussion started by: worchyld
18 Replies

9. Shell Programming and Scripting

How to delete a string pattern in a file and write back to the same file

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)
Discussion started by: mwrg
1 Replies

10. UNIX for Advanced & Expert Users

Problem with AIX: shared libraries aren't loaded

(4 Replies)
Discussion started by: edgarvm
4 Replies

11. UNIX for Dummies Questions & Answers

Shared static library

Hello Please what does mean shared static library and LD-Preload? Thank you (3 Replies)
Discussion started by: chercheur857
3 Replies

12. AIX

Shared Services Platform

We have a BI shop that uses a shared ETL server and a database cluster for the EDW and several different data marts catering to individual business groups. Of late, we have noticed that a lot of sloppy code has crept in and the ETL server (and sometimes the DB as well) seems to be maxing out on... (2 Replies)
Discussion started by: leonpanokarren
2 Replies

13. Shell Programming and Scripting

sed for first instance of a pattern

Hi Everyone, I have the below information from a log file: LOAD SUMMARY ============ WRT_8036 Target: TGT_1_TAB (Instance Name: ) WRT_8039 Inserted rows - Requested: 3929 Applied: 0 Rejected: 3929 Affected: 0 Mutated from update: 3929 WRT_8041 Updated rows ... (7 Replies)
Discussion started by: galaxy_rocky
7 Replies

14. Shell Programming and Scripting

SQLLDR :Data not loaded completely

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)
Discussion started by: Pratiksha Mehra
3 Replies

15. UNIX for Beginners Questions & Answers

Replace only First Word in Line

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)
Discussion started by: kaushik02018
1 Replies