5

Drop Schema from Postgresql

view full story
linux-howto

http://serverfault.com – I am trying to execute a few postgres commands from a bash file. I am trying to drop a schema by writing the following line DROP SCHEMA "xxx" IF EXISTS I have two issues here I am not sure how to specify the db from which the schema should be deleted I am getting the following error message -- "DROP: command not found" Can anyone help me with this issue? (HowTos)

taskli's picture
Submitted by taskli on 01/03/2012 – Made popular on 01/03/2012

Stories similar to Drop Schema from Postgresql

Hi M trying to install sendmail server on rhel6.i am having problem in setting up openldap. Please help

regards Mukesh following is slapd.conf

# # See slapd.conf(5) for details on configuration options. # This file should NOT be world readable. #

include /etc/openldap/schema/corba.schema include /etc/openldap/schema/core.schema include /etc/openldap/schema/cosine.schema include /etc/openlda

I'm trying to install an openldap server (slapd) on a Debian EC2 instance. I have followed all the instructions I can find, and am using the recommended slapd-config approach to configuration.

We're trying to get an instance of OpenLDAP up and running. I'm using ApacheDS as the browser. When I go to create my objects in the LDAP database, I see that a number of the objects and attributes don't fit the purpose for which I intend on using it.

I started to write my own Gnome Shell Extensions and can't find any answer to this question -> is there any way, how to install gsettings schema on machine just via extension code (e.g. not copying schema.xml into glib-2.0/schemas directory and compiling by terminal)?

I've included apple.schema, apple_auxillary.schema, and samba.schema in the slapd.conf file. Rebooted the slapd service with no errors. When I try to connect to the OpenLDAP server with Workgroup Manager this is the error I get in my Console.

Workgroup Manager[46635]: -[LoginController gotServerError:forTransaction:]: got error kNetworkError from request (null)

Any suggestions are welcome.

I've tried to follow the nutch tutorial but having a bit of a problem with the schema.xml file.

I was told to the nutch provided schema to my project, essentially this...

cp ${NUTCH_RUNTIME_HOME}/conf/schema.xml ${APACHE_SOLR_HOME}/example/solr/conf/

I have deployed my solr file in Tomcat and the error I get when I go to the Solr dashboard is

collection1: org.apache.solr.common.SolrException:

I'm trying to install and configure cassandra programmatically using a shell script. I install cassandra, run ./cassandra and then I try to load the schema using cassandra-cli --host localhost -f <schema-file>. The problem is that it tries to load the schema before cassandra is up and throws an exception. Is there any way to know when cassandra is up and running?

Thanks!

I need to store account creation and expiry dates in our existing ldap. None of the standard existing schemas seem to quite fit the bill, not even ppolicy or samba.

The answer I've come across so far is: "use a custom schema".

Fine, but I can't seem to find an existing custom schema to hold account creation and expiry dates.

I am trying to put the Compiz Fusion Icon in the systems tray I tried the following

gsettings set com.canonical.Unity.Panel systray-whitelist ['JavaEmbeddedFrame', 'Wine', 'Update-notifier', 'Fusion-icon']

& got back

Usage: gsettings [--schemadir SCHEMADIR] set SCHEMA[:PATH] KEY VALUE

Set the value of KEY to VALUE

Arguments: SCHEMADIR