Hello,
I'd like to move some tables from a particular database onto a different set
of disks. However, I can't see any robust way of achieving this. I've
tried using symlinks but these can easily be broken by a mixture of "vacuum
full" and growing the table again (assuming the table is large eno
Hi,
Looks like I should get to know the "Filesystem Hierarchy Standard" atleast
a little better.
The RPM distributions of PG use /var/lib/pgsql/data as the standard
PGDATA value. I'm not sure what Debian does but I think it might be
different. Also there has been some talk of including the majo
Hi,
Has anyone here already chrooted PostgreSQL that can explain the process ?
Or provide a good link ?
It must support Apache and PHP.
I've googled around, but found nothing interesting :(
Any help would be apreciated.
Warm Regards.
--
Mário Gamito
Administração de sistemas e desenvolvimento
Netua
On Wed, Dec 15, 2004 at 11:14:03PM -0800, William Yu wrote:
>
> I'm not sure why people say one is better than the other. Both will
> survive the loss of 2 drives -- they're just different drives.
Partly, I think, people who've used both hate 0+1 because of the
recovery cost. In most 0+1 arrang
Greetings,
We are in the process migrating to a new database and web server. We are
thinking running Postgress SQL on OS X as the back end database server and
BlueDragon ColdFusion on OS X as the web server. Has anyone done this
before? Any issues with this set up?
Thank you for your responses.
Hi,
I installed redhat 9.0 and postgresql was part of the
distribution. When I tried to start it with /etc/rc.d/init.d/postgresqld start,
I get
Starting Postgresql Service: Standard in must be in tty [FAILED]
I need help to get the server running. Thank you for your
time. I will appre
Title: missing schemas from template1
Hi,
Our provider tries to install postgresql 8.0.0-rc1 on a s390 machine (suse 7 or like).
They compiled the source and installed it without problems, and init_db looks to
worked well too. But there is not any schema in template1 database, so we can't
On Thu, Dec 16, 2004 at 05:44:09PM -, Donald Fraser wrote:
>
> Ok the problem is that outside our local network, and more precise on the
> outside of our firewall, users do not receive NOTIFY messages. The exact
> same software running on the local network, albeit not using SSL does
> recei
[EMAIL PROTECTED] writes:
> On Thu, 16 Dec 2004, Michael Fuhr wrote:
>> How are you determining that there are no schemas? Might you be
> Connecting with pgadmin3 to template1.
Perhaps you need a newer version of PGAdmin3.
regards, tom lane
---(e
Did you turn on the "view system objects" thingy in pgadmin3? That's too
technical%| Okay, I just checked and it's Display->System Objects.
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Iain wrote:
> >> Is there a "standard" directory that people tend to use for this,
> >> such as /var/local/pgsql/ ?
>
> > According to the Filesystem Hierarchy Standard, program data should
> be
> > under
[EMAIL PROTECTED] writes:
> On Thu, 16 Dec 2004, Tom Lane wrote:
>> It's difficult to believe that those aren't there, or that the database
>> would appear to work if they were not.
> The databse is not useable, so that's right.
>> Are you able to do, say, "select
>> * from pg_namespace"?
> The
On Thu, 2004-12-16 at 11:59, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > On Thu, 16 Dec 2004, Tom Lane wrote:
> >> It's difficult to believe that those aren't there, or that the database
> >> would appear to work if they were not.
>
> > The databse is not useable, so that's right.
>
> >> Are
On Thu, 16 Dec 2004, Tom Lane wrote:
It's difficult to believe that those aren't there, or that the database
I think it is an initdb problem.
would appear to work if they were not.
The databse is not useable, so that's right.
Are you able to do, say, "select
* from pg_namespace"?
The system is clo
On Thu, 16 Dec 2004, Michael Fuhr wrote:
How are you determining that there are no schemas? Might you be
Connecting with pgadmin3 to template1.
This is a different issue, but you aren't trying to work in template1,
are you? Template1 is the skeleton used when creating new databases --
you should
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
Sent: Thursday, December 16, 2004 5:07 PM
Subject: Re: [ADMIN] Notifications
On Thu, Dec 16, 2004 at 02:20:07PM -, Donald Fraser wrote:
I'm having problems receiving NOTIFY messages when outside our local
network.
Define
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> Could there be some sort of problem with SSL ?
No, I don't believe that one either.
As Michael Fuhr says, you need to be a lot more specific about what
problem you are seeing.
regards, tom lane
---(end
On Thu, Dec 16, 2004 at 03:38:06PM +0100, [EMAIL PROTECTED] wrote:
> Our provider tries to install postgresql 8.0.0-rc1 on a s390 machine
> (suse 7 or like). They compiled the source and installed it without
> problems, and initdb looks to worked well too. But there is not any
> schema in templ
On Thu, Dec 16, 2004 at 10:52:31 -0500,
FM <[EMAIL PROTECTED]> wrote:
> Hello,
> We have kerberos auth for all humain users, but I still need md5 auth
> for scripts users.
>
> All my scripts user name start with soft_
>
> Can I add soft_* in the pg_hba ?
You can't do pattern matching there.
Hello Tom,
On Thu, 16 Dec 2004 11:19:22 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Sam Mortimer <[EMAIL PROTECTED]> writes:
> > I'd like to move some tables from a particular database onto a
> > different set of disks. However, I can't see any robust way of
> > achieving this.
>
> PG 8.0 can d
Hmm I thought as much but I'm not really that up on socket connections to know
whether a connection could share both TCP and UPD packet types.
This leaves me rather clueless as to why I don't get NOTIFY messages accross
the internet yet I can connect, send and receive sql statements no problems.
On Thu, Dec 16, 2004 at 02:20:07PM -, Donald Fraser wrote:
> I'm having problems receiving NOTIFY messages when outside our local network.
Define "problems." What are you doing, what are you expecting to
happen, and what actually does happen? Have you tested whether you
have the same proble
On Thu, 16 Dec 2004, Tom Lane wrote:
Uh ... what schemas are you expecting to find there?
In normal cases there are:
information_schema
pg_catalog
pg_temp1
pg_toast
public
schemas. Without them the database is not really usefull. When I
create the first database (as copy of template1 of course) it
[EMAIL PROTECTED] writes:
> On Thu, 16 Dec 2004, Tom Lane wrote:
>> Uh ... what schemas are you expecting to find there?
> In normal cases there are:
> information_schema
> pg_catalog
> pg_temp1
> pg_toast
> public
> schemas. Without them the database is not really usefull. When I
> create the
[EMAIL PROTECTED] writes:
> Our provider tries to install postgresql 8.0.0-rc1 on a s390 machine
> (suse 7 or like). They compiled the source and installed it without
> problems, and initdb looks to worked well too. But there is not any
> schema in template1 database, so we can't really start ou
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> I'm having problems receiving NOTIFY messages when outside our local =
> network.
> I have dissabled firewall setting but nothing seems to fix the problem.
> I was wandering if NOTIFY messages use UDP or TCP, as that would =
> possibly explain why they
CRI74 - Fabien Combernous <[EMAIL PROTECTED]> writes:
> template1=# CREATE USER sympa WITH UNENCRYPTED PASSWORD 'kiki'
> NOCREATEDB NOCREATEUSER;
> CREATE USER
> template1=# \c - sympa
> Password:
> FATAL 1: Password authentication failed for user "sympa"
Perhaps you did this inside a BEGIN bloc
Sam Mortimer <[EMAIL PROTECTED]> writes:
> I'd like to move some tables from a particular database onto a
> different set of disks. However, I can't see any robust way of
> achieving this.
PG 8.0 can do this using tablespaces. There isn't any particularly
nice solution in earlier versions. If y
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Iain wrote:
>> Is there a "standard" directory that people tend to use for this,
>> such as /var/local/pgsql/ ?
> According to the Filesystem Hierarchy Standard, program data should be
> under /var/lib/. Indeed, many binary distributions use
> some
Hello,
We have kerberos auth for all humain users, but I still need md5 auth
for scripts users.
All my scripts user name start with soft_
Can I add soft_* in the pg_hba ?
thanks
---(end of broadcast)---
TIP 9: the planner will ignore your desire to
Hi,
Our provider tries to install postgresql 8.0.0-rc1 on a s390 machine
(suse 7 or like). They compiled the source and installed it without
problems, and initdb looks to worked well too. But there is not any
schema in template1 database, so we can't really start our work.
Is it a known problem
Iain wrote:
(B> Is there a "standard" directory that people tend to use for this,
(B> such as /var/local/pgsql/ ?
(B
(BAccording to the Filesystem Hierarchy Standard, program data should be
(Bunder /var/lib/. Indeed, many binary distributions use
(Bsome variant of that as data directory lo
Iain wrote:
As bytepile has it, failure of 1 disk in 0+1 leaves you with just RAID 0
so one more failure on the other pair and your data is gone. On the
other hand, failure of 1 disk in raid 10 leaves you with a working raid
1 that can sustain a second failure.
What they're saying is in the case
Hiya,
I'm having problems receiving NOTIFY messages when
outside our local network.
I have dissabled firewall setting but nothing
seems to fix the problem.
I was wandering if NOTIFY messages use UDP or TCP,
as that would possibly explain why they are not arriving?
Any ideas would be welcom
Hi all,
I am currently trying to create a development environment
including PostgreSQL 8.0.0rc1, R 2.0.1 and PL/R on a system running
Fedora Cora 1.
So far, I have suceeded in setting up PostgreSQL and R as
a shared library - unfortunately I have not been able to link these
two spheres by adding
Hello,
I'm trying to create new user. What is wrong in this ?
template1=# CREATE USER sympa WITH UNENCRYPTED PASSWORD 'kiki'
NOCREATEDB NOCREATEUSER;
CREATE USER
template1=# \c - sympa
Password:
FATAL 1: Password authentication failed for user "sympa"
Previous connection kept
template1=#
In log
Hello,
I'd like to move some tables from a particular database onto a
different set of disks. However, I can't see any robust way of
achieving this. I've tried using symlinks but these can easily be
broken by a mixture of "vacuum full" and growing the table again
(assuming the table is large eno
Hi All,
(B
(BI'm in the process of putting together some docs for a new postgres server.
(BFor development use, I've always just been content to have the PGDATA
(Bdirectory as a subdirectory of the main postgres install directory which is
(B/usr/local/pgsql/ by default (when installing from
Hi Aaron,
You are correct. That kind of functionality can't be found on standard
x86 gear (sans the $150K NEC redundant behemoth).
I reckon that the day is coming though, and I expect Linux will ready when
the hardware arrives :-)
cheers
Iain
---(end of broadcast)---
Thanks again for your valuable input William.
I'm not sure why people say one is better than the other. Both will
survive the loss of 2 drives -- they're just different drives.
RAID 0+1: A(1m1) s B(1m1) <-- any drive on A and any drive on B
RAID 10: A(1s1) m B(1s1) <-- both drives on A or both d
On Thu, 16 Dec 2004 11:18:37 +0900, Iain <[EMAIL PROTECTED]> wrote:
> Also, someone asked me what happens if one of the CPUs fails on this system,
> will the system continue to operate on 1 CPU. I havn't really considered
> this, and have never read anything either way, so my assumption is "no, it
41 matches
Mail list logo
