What exactly are you trying to do (coping data, program, ...)?
On what platform (most probably some sort of windows)?
What filesystem are you using?
With which version and package of postgresql are you working?
What directory are you talking about by 8.1 folder?
The error message says it clearly,
Dear sir,
I am encountering these errors
-bash-2.05b$ createuser -U postgres -d -A -P dspace
Enter password for new role:
Enter it again:
Shall the new role be allowed to create more new
roles? (y/n) n
createuser: relocation error: /usr/lib/libpq.so.4:
undefined symbol: krb5_cc_get_principal
-bas
Title: Error linking initdb
Hello,
I'm building postgresQL on Sparc10 and get following error. Did anybody see this error before and can suggest me a way to fix it?
Thank you all.
/usr/local/bin/gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-labels -fno-strict-alia
I'm trying to use schema and roles but I'm not having much success
(using PostgreSQL Database Server 8.1.2).
I want to set up a test area in the database using the schema "storage"
in the database "test".
There are 2 groups "storageadmin" and "storageuser".
"storageadmin" members should be a
i install the postgresql with service and create data base after that i uninstall it and install without service when i run it with pg_ctl its work fine but when i copy structure of 8.1 folder and overwrite it on other m/c or install postgresql folder and try to run the pg_ctl command then it
Sriram Dandapani wrote:
> Does the pg_total_relation_size take into account the free space map
> /"yet to be vacuumed data" ?
Both -- it measures the physical sizes of the files on disk, without
looking at the contents.
--
Alvaro Herrerahttp://www.CommandPrompt.
Hi
Does the pg_total_relation_size take into account the free
space map /”yet to be vacuumed data” ?
Ah, fair enough, table spaces are definitely the way to go then. I did
use it about a year ago to put one database on a different physical
drive, but I haven't used it for ages so cannot remember how to set it up.
Andy
Aaron Bono wrote:
> I think the tablespace option will work best - I will che
I think the tablespace option will work best - I will check it out. I do not give the users control of the database since I do the development, I just need a way to allocate the space and charge for space used. Since cPanel monitors user space, I don't want to rely on having to query the database
"Andy Shellam" <[EMAIL PROTECTED]> writes:
> I believe you could probably do this best with table spaces.
Right, that's the thing to use.
> There is a downside in that the user could create a new table and override
> the table space to that of another user.
Not with appropriate permissions set o
Hi Tom,
Actually I'm building it first time. The system didn't have prior
versions of postgreSQL installed. I took postgresql-8.1.3.tar.gz code
distribution.
I'll try to remove it from the code.
Thanks.
Stella Averbukh
_
Senior Software Lead, Arbitron Inc.
Ph
"Averbukh Stella" <[EMAIL PROTECTED]> writes:
> I'm building postgresQL on Sparc10 and the build goes fine unil initdb.
> /usr/local/bin/gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
> -Winline -Wendif-labels -fno-strict-aliasing initdb.o
> -L../../../src/port -lpgport -L../../../src/interfac
Hi Aaron
I believe you could probably do this best
with table spaces. You’ll have to look it up in the documentation
as I haven’t done it for a while.
You symlink a directory under
/pg_tblspc to another physical directory (eg. Your user’s
home/db directory), then when you create the d
Is there a way to get Postgres to store each database in a separate directory? I first hoped I could just use symbolic links under the data directory but I have no idea which files are assigned to which database.The reason I am wanting to do this is that I have a database set up for each user on m
On Tue, May 30, 2006 at 09:44:22AM -0400, Mr. Dan wrote:
> Hi,
>
> I have noticed that my full vacuum and re-index script is taking a day and
> a half instead of 1/2 day.
> Recently, the size of my database cluster has doubled to 130 GB. Would
> anyone recommend increasing one or more of these
Title: Problem building initdb on sparc10
Hi Andy,
I have no idea if it's Sparc specific. I usually do
Java development and last time I did large c/c++ build on unix platform was a
long time ago, so my skills in this area are a little bit
rusty.
Stella.
From: Andy Shellam
[mailto:[E
Title: RE: [ADMIN] Problem building initdb on sparc10
Although I did actually find this library on my system:
find / -name "libgcc_s.so.1"
/lib/libgcc_s.so.1
_
From: Averbukh Stella [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2006 3:45 pm
To: Andy S
Yes, I did try to set LD_LIBRARY_PATH. This is what it has right now.
# echo $LD_LIBRARY_PATH
/usr/sfw/lib:/lib:/platform/SUNW,Ultra-60/lib:/usr/local/lib:/usr/lib
Thanks.
Stella Averbukh
_
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTE
Title: Problem building initdb on sparc10
Hmm, I did the same on my system (Redhat
Fedora 3) and only got the following required libraries:
linux-gate.so.1 => (0xb7ff3000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7fa2000)
libresolv.so.2 => /lib/libresolv.so.2 (
Hi
[...]
I ran ldd on libpq.so ldd interfaces/libpq/libpq.so
libresolv.so.2 => /lib/libresolv.so.2
libsocket.so.1 => /lib/libsocket.so.1
libnsl.so.1 => /lib/libnsl.so.1
*libgcc_s.so.1 => (file not found)*
libc.so.1 => /lib/libc.so.1
libmp.so.2 => /lib/libmp.so.2
libmd5.so.1 => /lib/libmd5.so.1
Mr. Dan wrote:
> Hi,
>
> I have noticed that my full vacuum and re-index script is taking a day and
> a half instead of 1/2 day.
> Recently, the size of my database cluster has doubled to 130 GB. Would
> anyone recommend increasing one or more of these to help get my full
> vacuums to run a l
Title: Problem building initdb on sparc10
Andy,
thank you very much for the idea.
I tried what you
suggested even though -lgcc flag is usually used with -nostdlib and -nodefaultlibs
flags, which I do not use. In any case it didn't help.
thahks
again.
Stella
Averbukh ___
Hi,
I have noticed that my full vacuum and re-index script is taking a day and a
half instead of 1/2 day.
Recently, the size of my database cluster has doubled to 130 GB. Would
anyone recommend increasing one or more of these to help get my full vacuums
to run a little faster?
Thanks,
~DjK
Title: Problem building initdb on sparc10
Should you need to add –lgcc to the
linker path? (e.g. –L/usr/lib –lgcc) or –lgcc_s?
I had a similar thing with readline.
Just a guess!
Andy
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Averbukh Stella
Sent:
Title: Problem building initdb on sparc10
Hello,
I'm building postgresQL on Sparc10 and the build goes fine unil initdb.
/usr/local/bin/gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-labels -fno-strict-aliasing initdb.o -L../../../src/port -lpgport -L../../../src/i
25 matches
Mail list logo
