On Wed, Dec 07, 2005 at 10:53:37PM -0800, Benjamin Arai wrote:
> I have a database of several million records and we are currently
> developing pl functions and views. How do you dump only the code for
> views and functions?
pg_dump doesn't allow you to be that selective, but you could use
the
I have a database of several million records and we are currently
developing pl functions and views. How do you dump only the code for
views and functions?
Benjamin
---(end of broadcast)---
TIP 4: Have you searched our list archives?
I used pg_dump -u -F c -f E:\Temp\Test.tar.gz TestDB to
backup. Then, I dropped and recreated TestDB.
However, I failed to restore with this command pg_restore -u
-F c -d TestDB E:\Temp\Test.tar.gz.
Here is what I got :
pg_restore: [archiver (db)] connection to database
"TestDB" fa
On Wed, 2005-12-07 at 11:04 -0700, Anne M. Hammond wrote:
> If there is another way to do this, such as command line options
> or environmental values for initdb, I haven't found it.
There's no need to run initdb on the smaller machine.
Run the initdb on the larger machine, then *while postmaste
"Anne M. Hammond" <[EMAIL PROTECTED]> writes:
> However, when the server SHMMAX is smaller than the size required
> by the defaults for shared_buffers and max_connections, I have
> not been able to find a way (other than the above), to tell
> initdb to use a nondefault values.
Well, initdb is just
Summary:
I used a workstation where /usr/local/pgsql was mounted, and
which had a larger SHMMAX. initdb worked there.
Then I returned to the server, edited /usr/local/pgsql/data/pgsql.conf
for smaller sizes than the default shared_buffers and max_connections.
Thanks to Pandu and Tom Lane for
"sandhya" <[EMAIL PROTECTED]> writes:
> ERROR: could not create server file "/tmp/sss.txt": Permission denied
If /tmp is already mode 777, then the only reason I can think of for
this is that you've got SELinux turned on and it's configured to forbid
the postmaster from writing in /tmp. Possibly
"Anne M. Hammond" <[EMAIL PROTECTED]> writes:
> So the shared memory request is greater than the SHMMAX in
> the kernel. If I just wanted to use a smaller number of shared_buffers
> (24), I tried editing /usr/local/pgsql/data/pgsql.conf.
You're going to have to increase SHMMAX anyway, so you migh
Diego,
Please read the following documentation for a quick
start, and then come back with further questions / doubts:
http://www.postgresql.org/docs/7.4/interactive/sql-checkpoint.html
Best whishes,
GuidoOn 12/7/05, Diego <[EMAIL PROTECTED]> wrote:
Hi,I have a question about checkpoint in pg
Hi,
I have a question about checkpoint in pg_version 7.4.
What is this and how affect performance of database?
How can i configure this variable for more performance?
Thanks
Diego Ziquinatti
From Brazil
---(end of broadcast)---
TIP 9: In versions
Initially it worked fine for
tmpdirectory.
when i changed it to...
psql "dbname" -U root
from that time onwards it is not accepting even
/tmp
Where to change for these permissions.Pls explain
me what to do..I just started working on Linux
Thanks,
Sandhya
- Original Me
I did even i am not getting...Not only tmpin
all directories i am unable to export
- Original Message -
From:
R, Rajesh (STSD)
To: sandhya
Sent: Wednesday, December 07, 2005 3:37
PM
Subject: RE: [ADMIN] reg:file transfer
error
Try setting write perm
hi
when i am using select lo_export(filemanip.objid,'/tmp/sss.txt')
from filemanip where fname =
'/usr/sample.txt'
ERROR: could not create server file
"/tmp/sss.txt": Permission denied
please tell me what may be the
problem.Any permissions i have to change?
Where to modify inorder to
Hi,
The following link will help you
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
On 12/7/05, Anne M. Hammond <[EMAIL PROTECTED]> wrote:
> This is running on a Solaris 8 machine.
>
> I installed V 7.4.7 to use with OpenACS.
>
> lcd[34]% /usr/local/pgsql/bin/initdb -D /usr/loca
This is running on a Solaris 8 machine.
I installed V 7.4.7 to use with OpenACS.
lcd[34]% /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
...
selecting default max_connections... 10
selecting default shared_buffers... 50
creating configuration files... ok
creating template1 database in /usr/
15 matches
Mail list logo