Hello Everyone,
I have a pseries machine running AIX 4.3.3 that has an invalid IP in /etc/hosts. During a boot the system hangs because it's trying to mount an NFS share to this invalid IP.
I've tried to boot the system from a mksysb (not sure if the device was defined as rmt0) and AIX CD... (0 Replies)
Hi guys,
i encountered this error when i try to create a group. What is the problem here? I created a few groups weeks before this. I was recommended to reboot the machine, but i am not the owner of the machine, thus i would prefer to know the cause and any other solution other than rebooting the... (1 Reply)
Help! I work on a PC running Windows XP. I have installed the Hummingbird Suite Exceed 10.0. I launch 4 Xconfig sessions based on different *.cfg files along with the standard Xserver Xconfig (Exceed.cfg). I do this because I need to run graphical apps in separate windows. In any event,... (0 Replies)
Hi,
I am trying to lock a user by executing "passwd -l xxxx" but the system is returning following error:
Locking password for user xxxx.
passwd: Error (password not set?)
I do see the passwd for this user encrypted in shadow file thou! Anyone have any ideas why am getting this error?
... (5 Replies)
Hi,
I created a Solaris package, but at the end of installation (on a Solaris 10 sparc) I get :
#pkgadd -d MyApp_version__SunOS_sparc.pkg
...
Installation of <MyAppName> was successful.
pkgadd: ERROR: ERROR: Unable to release package administration lock for
this system; try again later... (0 Replies)
Hi,
I am unable to get beyond the exit function. The shell script is used to look for masked files and copy paste them to another location. Please refer to the code below for more information.
Thanks
Brinjit
#!/usr/bin/ksh... (10 Replies)
Hi All,
I created a nfs share in the server(Solaris 10) with the following command and also updated the dfstab file
share -F nfs -o rw=server_name2,anon=0 /to_share
And then in the client(solaris 10) added the following command to mount the share
mount -F nfs server_name1:/to_share... (4 Replies)
Hello,
While mounting NFS below error is coming:
# mount -t nfs 10.65.150.69:/lvsnap /lvsnap
mount: mount to NFS server '10.65.150.69' failed: RPC Error: Program not registered.
Please advise.
Best regards,
Vishal (2 Replies)
Hi,
I have exported a few nfs mounts from one server to the nfs clients.
This is my nfs server dfstab :
# cat /etc/dfs/dfstab
# place share(1M) commands here for automatic execution
# on entering init state 3.
#
# share <pathname>
# .e.g,
# share -F... (3 Replies)
My customer has created a share on a Windows Server 2012 system and exported it as a NFS share.
I can mount the share on a SCO system, but I only have read/write access. So I am unable to list the contents of the share. It is as if the directories had 0666 permissions.
My customer says that this... (5 Replies)
Discussion started by: jgt
5 Replies
LEARN ABOUT MOJAVE
create_tablespace
CREATE TABLESPACE(7) SQL Commands CREATE TABLESPACE(7)NAME
CREATE TABLESPACE - define a new tablespace
SYNOPSIS
CREATE TABLESPACE tablespacename [ OWNER username ] LOCATION 'directory'
DESCRIPTION
CREATE TABLESPACE registers a new cluster-wide tablespace. The tablespace name must be distinct from the name of any existing tablespace in
the database cluster.
A tablespace allows superusers to define an alternative location on the file system where the data files containing database objects (such
as tables and indexes) can reside.
A user with appropriate privileges can pass tablespacename to CREATE DATABASE, CREATE TABLE, CREATE INDEX or ADD CONSTRAINT to have the
data files for these objects stored within the specified tablespace.
PARAMETERS
tablespacename
The name of a tablespace to be created. The name cannot begin with pg_, as such names are reserved for system tablespaces.
username
The name of the user who will own the tablespace. If omitted, defaults to the user executing the command. Only superusers can create
tablespaces, but they can assign ownership of tablespaces to non-superusers.
directory
The directory that will be used for the tablespace. The directory must be empty and must be owned by the PostgreSQL system user. The
directory must be specified by an absolute path name.
NOTES
Tablespaces are only supported on systems that support symbolic links.
CREATE TABLESPACE cannot be executed inside a transaction block.
EXAMPLES
Create a tablespace dbspace at /data/dbs:
CREATE TABLESPACE dbspace LOCATION '/data/dbs';
Create a tablespace indexspace at /data/indexes owned by user genevieve:
CREATE TABLESPACE indexspace OWNER genevieve LOCATION '/data/indexes';
COMPATIBILITY
CREATE TABLESPACE is a PostgreSQL extension.
SEE ALSO
CREATE DATABASE [create_database(7)], CREATE TABLE [create_table(7)], CREATE INDEX [create_index(7)], DROP TABLESPACE [drop_tablespace(7)],
ALTER TABLESPACE [alter_tablespace(7)]
SQL - Language Statements 2010-05-14 CREATE TABLESPACE(7)