I wrote a little script to individually back up table schemas, table
data and then vacuum the table and it works nicely but I wanted a way to
query a database and get a text file with just the table names and
cannot figure out a way to do that.
my script looks like this...
(all I want is to get a
On Thu, 2007-11-01 at 20:25 +0100, hubert depesz lubaczewski wrote:
> On Wed, Oct 31, 2007 at 08:01:41AM -0700, Craig White wrote:
> > my script looks like this...
> > (all I want is to get a list of the tables into a text file pg_tables)
>
> everybody else showed some
On Fri, 2007-11-09 at 23:55 -0500, Mark Niedzielski wrote:
> Our developers run on MacBook Pros w/ 2G memory and our production
> hardware is dual dual-Core Opterons w/ 8G memory running CentOS 5. The
> Macs perform common and complex Postgres operations in about half the
> time of our unloaded pr
On Mon, 2007-11-26 at 17:37 -0600, Wes wrote:
> On 11/13/07 10:02 AM, "Scott Ribe" <[EMAIL PROTECTED]> wrote:
>
> > What you're referring to must be that the kernel was essentially
> > single-threaded, with a single "kernel-funnel" lock. (Because the OS
> > certainly supported threads, and it was
On Sun, 2008-05-18 at 23:33 -0700, [EMAIL PROTECTED] wrote:
> Wow...so does no one use phppgadmin on servers that they are connected
> to via the internet? Or if you do, how do you go about securing it so
> that no one snoops your password?
>
> Thanks
>
>
> On May 16, 12:34 am, "[EMAIL PROTECTE
On Thu, 2008-08-07 at 17:24 -0400, Jack Orenstein wrote:
> Pardon a dumb question. Installing Postgres 7.x on FC4-6, I would install a
> large set of RPMs, these I think:
>
> postgresql
> postgresql-contrib
> postgresql-devel
> postgresql-jdbc
> postgresql-libs
> pos
CentOS 4.4 which means postgresql-server-7.4.13-2.RHEL4.1
I'm starting to deal with the notion of allowing other users access
(read only) to a db.
Experimenting on my own db...
hostall main_user 192.168.2.10255.255.255.0 trust
hostall all 127.0.0.1 2
On Thu, 2006-11-09 at 12:34 -0300, Alvaro Herrera wrote:
> Craig White wrote:
>
> > logs say...
> > Nov 8 20:18:26 srv1 postgresql: Starting postgresql service: succeeded
> > Nov 8 20:18:39 srv1 postgres[21020]: PAM audit_open() failed:
> > Permission denied
>
On Thu, 2006-11-09 at 11:51 -0500, Tom Lane wrote:
> Craig White <[EMAIL PROTECTED]> writes:
> > I haven't had to fool too much with pam for authenticating other
> > services so I'm a little bit out of my knowledge base but I know that it
> > was simple to add
On Thu, 2006-11-09 at 16:34 -0300, Alvaro Herrera wrote:
> Tom Lane wrote:
> > Craig White <[EMAIL PROTECTED]> writes:
> > > I haven't had to fool too much with pam for authenticating other
> > > services so I'm a little bit out of my knowledge base
Just in case others follow in my footsteps - this may prove to be
helpful.
Summary of problem: CentOS 4.4 - SELinux enabled - authorizing pam based
users
### Created file /etc/pam.d/postgresql (I'm using LDAP) [*]
# cat /etc/pam.d/postgresql
#%PAM-1.0
auth required pam_stack.so service=
On Fri, 2007-03-09 at 01:22 +, Bradley Kieser wrote:
> I hope that someone has cracked this one because I have run into a brick
> wall the entire week and after 3 all-nighters with bad installations, I
> would appreciate hearing from others!
>
> I am looking for a decent OpenSource CRM syste
How do I change the owner of a schema?
ALTER SCHEMA "public" OWNER to "some_user"; #?
Craig
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On Mon, 2006-02-13 at 11:07 +0900, Michael Glaesemann wrote:
> On Feb 13, 2006, at 10:29 , Craig White wrote:
>
> > How do I change the owner of a schema?
> >
> > ALTER SCHEMA "public" OWNER to "some_user"; #?
>
> http://www.postgresql.org/docs
On Mon, 2006-02-13 at 11:39 +0900, Michael Glaesemann wrote:
> On Feb 13, 2006, at 11:27 , Craig White wrote:
>
> > th-db_test=> ALTER SCHEMA public OWNER TO tobyhouse;
> > ERROR: syntax error at or near "OWNER" at character 21
> >
> > # rpm -q post
On Tue, 2006-04-11 at 23:13 +0200, Magnus Hagander wrote:
> > Hello,
> >
> > I am trying to import an Excel file in my database (8.0.7). I
> > think I am supposed to create an CSV file out of my Excel
> > file and somehow, feed the database with it. My pronblem is
> > that I don't really know h
On Wed, 2006-04-12 at 17:57 +0200, Magnus Hagander wrote:
> > > \copy "Flight Traffic" from yourfile.csv delimiter as ','
> > csv quote as
> > > '"'
> > >
> > > (might need some adaption, of course)
> > >
> > >
> > > Loading 45,000 lines is trivial for copy, it shouldn't take
> > noticable
>
I am getting an error when I import, invalid input syntax for type
boolean - which is empty. Is there any way around this of must I
necessarily have \N ?
Craig
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
strugging to import
I connect and am on the command line but I don't think I am in the right
schema. I have looked through the /h /? but can't seem to figure out how
to change to
database: th-db
schema: db
version: # rpm -q postgresql
postgresql-7.4.8-1.RHEL4.1
Craig
-
19 matches
Mail list logo
